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 |