left outer join 2 or 3 tables in ms access
Hi,
I have the following query.
This query works perfect when working with ms sql but when I try to use it with access db I get syntax error.
How can I use it with access???
when there is one "left outer join" no problem but with more than 1 we have difficulty.
RS1.Open "select Top 5 *,Exp_Users.*,(SELECT COUNT (*) from Exp_Answers WHERE Exp_questions.QID = 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 where Exp_Questions.Status=1 order By Exp_Questions.Date_asked Desc" ,Conn,3,3
|