asp + access 多表查詢的問題--sql語句
SELECT b.REnames, b.REneirong,b.REabout,a.names,a.UserXY ,a.TruName, a.UserSex, a.UserLove,c.id,c.neirong FROM userss AS a LEFT JOIN (REchecklist AS b left outer join checklist as c on b.REabout=c.id) on names=b.REnames.......然後我想要再加一個限制條件.就是說.c.id=32 我怎麽樣才能加進去呢.......
整個過程是這樣的:
兩個表:1.REcehcklist 2.userss
REchecklist 有字段:REnames , REneirong ,REabout
userss有字段:names , Trunames , Userlove , UersXY , UserSEX
checklist 有字段:id , neirong
REnames.value=names.value
REabout.value=id.vlaue
現在再加一個限制條件:就是讓id=request.QueryString("id")
請高手幫忙給個方法,或是完整的例子
