Hi,
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

Hii keyvanjan!!
 use parentheses to solve it
as per for my logintable

SELECT logintable.id, logintable.code, *
FROM ((logintable LEFT outer JOIN logintable AS logintable_1 ON logintable.id = logintable_1.id) LEFT outer JOIN logintable AS logintable_2 ON logintable_1.id = logintable_2.id) LEFT outer JOIN logintable AS logintable_3 ON logintable_2.id = logintable_3.id;

to sort out your query you can also use query in design view and check it

Hope this will help you

Cheers :)

vinod