3,491
社区成员
发帖
与我相关
我的任务
分享
----具体要看限制条件了,最好用left join
select a.号码 AS HM,
a.DAT_ AS JHRQ,
a.计划时间 AS JHSJ,
a.预计时间 AS YJSJ,
a.实际时间 AS SJSJ,
NVL(a.型号,b.XH)XH,
NVL(A.JW,B.JW)JW,
NVL(A.JWLX,B.JWLX)JWLX,
NVL(A.JCBZ,B.JCBZ)JCBZ,
A.发送方 AS FS,
NVL(A.JT1,B.JT1)JT1,
NVL(A.JT2,B.JT2)JT2,
NVL(A.jt3,B.JT3)JT3,
A.接收方 AS JS,
A.任务 AS RW,
NVL(A. SX, b. SX) SX
from test1 a,
left join test2 b
where a.DAT_=b.Jhrq and 限制条件