在sql server中能实现
select c.*,d.u_ChineseName as SCChineseName,d.u_ID as SCID,e.u_ChineseName as DChineseName,e.u_ID as DID,b.r_datetime
from Patient a
left join Registration b on a.p_ID=b.p_ID
left join PrescriptionRecord c on b.r_ID=c.r_ID
left join Users d on b.u_ID=d.u_ID
left join Users e on c.u_DID=e.u_ID
在oracle中怎么实现?
PS:oracle中leftjoin好像不能给表再做别名,但是本查询需要对users表进行两次关联,sql中用别名区分来实现的,请问oracle中如何实现
select c.*,d.u_ChineseName as SCChineseName,d.u_ID as SCID,e.u_ChineseName as DChineseName,e.u_ID as DID,b.r_datetime
from Patient a
left join Registration b on a.p_ID=b.p_ID
left join PrescriptionRecord c on b.r_ID=c.r_ID
left join Users d on b.u_ID=d.u_ID
left join Users e on c.u_DID=e.u_ID
在oracle中怎么实现?
PS:oracle中leftjoin好像不能给表再做别名,但是本查询需要对users表进行两次关联,sql中用别名区分来实现的,请问oracle中如何实现
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货