SQLÓï¾äÎÊÌ⣬ÔÚÏßµÈ

Ö´ÐиöÎ
select * from
(
select a.*,b.register_date,b.staff_msisdn,b.¹éÊô»ú¹¹
from (select * from lmf_hlwzx_200912 where to_char(create_time,'yyyymm')=200912) a,
    (select * from qz_jj_1.ban_dj_200912_done where »ý·ÖÏîÄ¿ like '%רÏß%') b
where a.payment_msisdn=b.msisdn ) where  operator_id= 5021203
½á¹û£ºµÃµ½6¼Ç¼
and operator_id not in (select operator_id from qz_jj_1.jj_dls_wkno);

Ö´ÐиöÎ
select * from
(
select a.*,b.register_date,b.staff_msisdn,b.¹éÊô»ú¹¹
from (select * from lmf_hlwzx_200912 where to_char(create_time,'yyyymm')=200912) a,
    (select * from qz_jj_1.ban_dj_200912_done where »ý·ÖÏîÄ¿ like '%רÏß%') b
where a.payment_msisdn=b.msisdn ) where  operator_id not in (select operator_id from qz_jj_1.jj_dls_wkno);
½á¹û£ºÃ»ÓÐÈκμǼ
È»¶øÖ´ÐÐ
select * from qz_jj_1.jj_dls_wkno where operator_id = 5021203ҲûÓмǼ

°´µÀÀíÖ´Ðеڶþ¶ÎµÄʱºò£¬Ó¦¸ÃÖÁÉÙÓÐ6Ìõ¼Ç¼£¬È»¶øȴûÓУ¬ÕâÊÇΪʲô£¬ÇëÐÖµÜÃÇ°ï°ïæ~~~

---

Ö´ÐиöÎ
select * from
(
select a.*,b.register_date,b.staff_msisdn,b.¹éÊô»ú¹¹
from (select * from lmf_hlwzx_200912 where to_char(create_time,'yyyymm')=200912) a,
    (select * from qz_jj_1.ban_dj_200912_done where »ý·ÖÏîÄ¿ like '%רÏß%') b
where a.payment_msisdn=b.msisdn )