selectTxt="select * from dutydis join person on dutydis.pID=person.pID join indexs on dutydis.idxNum=indexs.idxNum where person.pID=1";
也可以select * from dutydis join indexs on dutydis.idxNum=indexs.idxNum join person on dutydis.pID=person.pID where person.pID=1
好像只可以where第一个表也就是dutydis
selectTxt="select * from dutydis WHERE PID=1 join person on dutydis.pID=person.pID join indexs on dutydis.idxNum=indexs.idxNum ";
select * from dutydis d join person p on d.pID = p.pID join indexs i on d.idxNum = i.idxNum where p.pID=1
select * from dutydis d join person p on d.pID = p.pID join indexs i on d.idxNum = i.idxNum where p.pID=1 ------------------------------------------------- 两表字段名一样的话就要加上表名
indexs表中没有pID字段,应该怎么办?谢谢高歌
from dutydis join indexs
on dutydis.idxNum=indexs.idxNum
join person
on dutydis.pID=person.pID
where person.pID=1
from dutydis d join person p on d.pID = p.pID
join indexs i on d.idxNum = i.idxNum
where p.pID=1
from dutydis d join person p on d.pID = p.pID
join indexs i on d.idxNum = i.idxNum
where p.pID=1
-------------------------------------------------
两表字段名一样的话就要加上表名