I have the following query which has 3 left outer join
The UserID field exist in 2 tables questions table and answers table
I want the field userID in the questions table but the other one is shown when I output it.
How can I display the userID from the questions table???



RS1.Open "select *,(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