22,206
社区成员
发帖
与我相关
我的任务
分享
select * from tableA , tableB ,tableC
where A.ap_no=B.ap_no AND B.ps_no=C.ps_no
AND os_no=某个值
select a.*
from tablea a , tableb b , tablec c
where a.ap_no = b.ap_no and b.ps_no = c.ps_no and c.os_no=某个值
select a.* from tablea a
inner join tableb b on a.ap_no = b.ap_no
inner join tableb c on b.ps_no = c.ps_no
where c.os_no=某个值
select A.*
From TableA A
Join TableB B on B.ap_no = A.ap_no
Join TableC C on C.ps_no = B.ps_no
where C.os_no = value