sel *
from HEMSS.Hems_C_Fct_Area_Result_C_T
where Billing_Month_Cd = 200907
-73 51 200907
sel *
from HEMSS.Hems_C_Fct_Area_Result_C
where Billing_Month_Cd = 200906
and Mkt_Row_Id = 51
-73 51 200906
6576 51 200906
6681 51 200906
6392 51 200906
SEL P1.Mkt_Row_Id,P1.Comm_Id,P1.Billing_Month_Cd,P2.Mkt_Row_Id,P2.Comm_Id,P2.Billing_Month_Cd
FROM (
select *
from HEMSS.Hems_C_Fct_Area_Result_C_T
where
Billing_Month_Cd = 200907
and MKT_ROW_ID = 51)P1
FULL JOIN (
select *
from HEMSS.Hems_C_Fct_Area_Result_C
where Billing_Month_Cd = 200906
AND MKT_ROW_ID = 51) P2
ON P1.Mkt_Row_Id = P2.Mkt_Row_Id
AND P1.Comm_Id = P2.Comm_Id
;
51 -73 200907 51 -73 200906
? ? ? 51 6576 200906
? ? ? 51 6681 200906
? ? ? 51 6392 200906
阅读(947) | 评论(0) | 转发(0) |
