作者dicky (梦 终究还是梦)
看板Database
标题Re: [SQL ] 选出两个资料表中要的值
时间Fri Dec 5 12:02:56 2008
看看这样可不可以
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)