select
Max(kian_date) as MaxKianDate
from
(select a.KIAN_DATE as KIAN_DATE
from RINGI_TBL a,RINGIMEISAI_TBL b,FAVORITES_TBL c
where c.SYSYNO=a.KIANSYA_CODE and c.KANRISYA_CODE=b.KAIGISYA_CODE and a.ID=b.ID
Union
select d.HOKOKU_DATE as KIAN_DATE
from HOKOKU_TBL d,HOKOKUMEISAI_TBL e,FAVORITES_TBL f
where f.SYSYNO=d.HOKOKUSYA_CODE and f.KANRISYA_CODE=e.KAIGISYA_CODE and d.ID=e.ID) as tt
Max(kian_date) as MaxKianDate
from
(select a.KIAN_DATE as KIAN_DATE
from RINGI_TBL a,RINGIMEISAI_TBL b,FAVORITES_TBL c
where c.SYSYNO=a.KIANSYA_CODE and c.KANRISYA_CODE=b.KAIGISYA_CODE and a.ID=b.ID
Union
select d.HOKOKU_DATE as KIAN_DATE
from HOKOKU_TBL d,HOKOKUMEISAI_TBL e,FAVORITES_TBL f
where f.SYSYNO=d.HOKOKUSYA_CODE and f.KANRISYA_CODE=e.KAIGISYA_CODE and d.ID=e.ID) as tt
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货