SELECT
b.latn_id,
b.interserv_id,
b.serv_id
,
b.interacct_id,
b.acct_id
,
b.intercust_id,
b.cust_id
,
a.ACC_NBR
,
-1 FEE_GRADE_ID,
a.billing_month MONTH_TIME_ID
,
nvl(c.region_dim_id,-1) REGION_DIM_ID
,
-1 PRODUCT_DIM_ID
,
-1 CUST_TYPE_DIM_ID,
-1 join_time
,
-1 USER_TYPE_ID
,
a.charge fee,
to_char(sysdate,'yyyymm') TIME_MARK
from tmp_test a,interserv b,bak_dim_region c
whereb.latn_id=901 and a.ACC_NBR=b.ACCNBR(+) and c.latn_id=b.latn_id
and b.area_id=c.area_id
and a.billing_month='200401' and a.state in('20C','20E','20T')
and a.acc_nbr='TCADSL00242';
问a表的东西怎么关联不到,我已经用了外连接了?
a.ACC_NBR=b.ACCNBR(+) |