在左连接
SELECT A.TEN_CD, B.TEN_NM, A.GINKO_KIN, A.JITU_NYUKIN, A.TSURI_KIN, A.URI_DATE
FROM U011TENJ A, M006TENM B WHERE A.TEN_CD(+) = B.TEN_CD
AND A.URI_DATE>= '20040101' AND A.URI_DATE <= '20040801'
order by URI_DATE,TEN_CD.
SELECT A.TEN_CD, B.TEN_NM, A.GINKO_KIN, A.JITU_NYUKIN, A.TSURI_KIN, A.URI_DATE
FROM U011TENJ A, M006TENM B WHERE A.TEN_CD(+) = B.TEN_CD
AND A.URI_DATE>= '20040101' AND A.URI_DATE <= '20040801'
order by URI_DATE,TEN_CD.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货