首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > ASP >

高手在那?帮忙改一下,多表查询,多谢啦

2012-02-15 
高手在那?帮忙改一下,多表查询,谢谢啦。sql_select*fromtabJobwhereComtabCom.Company(wheretabCom.User

高手在那?帮忙改一下,多表查询,谢谢啦。
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& ' "

热点排行