Re: [SQL ] 選出兩個資料表中要的值

[dicky (夢 終究還是夢)]

看看這樣可不可以


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)