SQL

OUTER JOIN 사용예

십억10 2009. 7. 21. 14:10

SELECT A.SDATE

,A.OUTLET
,D.STORE_NM_KOR
,A.BILL
,B.SALETIME
,B.MENUCODE
,E.MENU_NM
,B.PRICE
,B.QTY
,B.NETAMT
,ISNULL(C.GRP_NM,'') AS GRP_NM
,ISNULL(C.DTL_NM,'') AS DTL_NM
,B.DCRATE
   ,B.DCAMT

 FROM POSALHEADER A LEFT OUTER JOIN COMMONCD C

ON  C.SYS_CD = '04'
AND C.DTL_CD = SUBSTRING(A.DCREASON, 5, 2)
AND C.GRP_CD = SUBSTRING(A.DCREASON, 1, 4)

,POSALITEM B
,STORE D
,MENU E

 WHERE A.SDATE BETWEEN '20090601' AND '20090602'

AND A.OUTLET LIKE '%' + '' + '%'
AND D.BRAND_CD = '002'
AND E.BRAND_CD = '002'
AND B.MENUCODE = E.MENU_CD
AND A.DCREASON LIKE '%' +'' + '%'

AND A.OUTLET = D.STORE_CD
AND A.SDATE = B.SDATE
AND A.OUTLET = B.OUTLET
AND A.POSNO = B.POSNO
AND A.BILL = B.BILL

 ORDER BY A.SDATE, A.OUTLET,A.BILL,B.MENUCODE,B.SALETIME

'SQL' 카테고리의 다른 글

[MSSQL] UPDATE 활용  (0) 2010.04.14
MS-SQL 날짜 합과 차  (0) 2009.10.28
union all 사용예  (0) 2009.07.21
SQL 내장함수  (0) 2009.01.19