![]() |
#2
qingshuiliu2010-09-01 10:40
|
只有本站会员才能查看附件,请 登录
为什么出现重复的部分呢?sql语句如下:select b.businessid,b.jobtitle,b.time,b.address,bq.qualification,bj.jobduties
from business as b join BQualifications as bq on b.businessid=bq.businessid join BJob_duties as bj
on b.businessid=bj.businessid where b.businessid=1 and bq.businessid=1 and bj.businessid=1
查找三张表中的信息,三张表中都有businessid,business、BQualifications、BJob_duties 这三张表是主外键关系
请高手帮忙找下 好需要加什么条件吗?