高手在那？帮忙改一下，多表查询，谢谢啦。
sql_ = "select * from tabJob where Com = tabCom.Company (where tabCom.UserName=session( "Email ")) "
目的：要查询tabJob表中的字段，有三张表，关系是
tabJob(Com)------tabCom(Company)

tabCom(UserName)-----tabUser(Email)

Email=session( "Email ")
Email是传过来的


[解决办法]
select * from tabjob as j,tabcom as c,tabuser as u where u.username = c.username and c.company = j.com and u.email = 'mail地址 '
[解决办法]
自用计算机图书要出售

http://store.taobao.com/shop/view_shop.htm?asker=wangwang&shop_nick=chens616
[解决办法]
email=session( "Email ")

sql_ = "select * from tabJob as A left join tabJob as B on A.id=B.id left join tabUser as C on A.id=C.id where A.Com=B.Company and B.UserName= " '&email& ' "