17,377
社区成员
发帖
与我相关
我的任务
分享
select nvl(a.IYEAR, b.IYEAR) as IYEAR, nvl(a.IT, b.IT) as IT, nvl(a.IMONTH, b.IMONTH) as IMONTH, nvl(a.SFCODE, b.SFCODE) as SFCODE, b.IJX2, a.IMONERY
from a
full join b on (a.IYEAR=b.IYEAR and a.IT=b.ITand a.IMONTH=b.IMONTH and a.SFCODE=b.SFCODE)
select nvl(a.IYEAR, b.IYEAR) as IYEAR, nvl(a. IT, b. IT) as IT, nvl(a. IMONTH, b. IMONTH) as IMONTH, nvl(a. SFCODE, b. SFCODE) as SFCODE, b.IJX2, a.IMONERY
from a
full join b on (a.IYEAR=b.IYEAR and a.IT=b.ITand a.IMONTH=b.IMONTH and a.SFCODE=b.SFCODE)
select IYEAR, IT, IMONTH, SFCODE, 0 IJX2, IMONERY from A
union all
select IYEAR, IDEP, IMONTH, SFCODE, IJX2, 0 IMONERY from B