Re: [SQL ] 選出兩個資料表中要的值
看看這樣可不可以
select * from C
join A
on C.parkOwn=A.studId and C.parkOwn='T2'
union all
select * from C
join B
on C.parkOwn=B.teachId and C.parkOwn='T2'
不確定你的意思
如果你要用胡刮來搜尋的話
select * from C
join A
on C.parkOwn=A.studId and A.studName='胡刮'
union all
select * from C
join B
on C.parkOwn=B.teachId and B.teachName='胡刮'
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 61.218.10.19
※ 編輯: dicky 來自: 61.218.10.19 (12/05 12:05)