left outer join
I use MS ACCESS
The following query works when I user just 1 left outer join with parenthesis but with one than 1 left outer join I get syntax error
what should I do?
RS1.Open "select *,exp_questions.userid,(SELECT COUNT (*) from Exp_Answers WHERE Exp_questions.ID = Exp_Answers.QID ) AS REC_COUNT from ( Exp_questions left outer join Exp_Users on Exp_Questions.UserID=Exp_Users.UserID ) left outer join Exp_Category on Exp_Category.CatID=Exp_Questions.CatID left outer join Exp_SUBCategory on Exp_SubCategory.SubID=Exp_Questions.SubID left outer join Exp_Answers on Exp_Answers.QID=Exp_Questions.ID where Exp_Questions.QID=" & intQID ,Conn,3,3