OUTER JOIN 사용예

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