query로 하시면 될 듯 합니다.



SELECT P.NAME, D.DEPARTNAME, S.SUBDEPARTNAME, T.TITLENAME, P.PERSONID, VM.BREAKFIRST, VM.LUNCH, VM.DINNER,

( VM.BREAKFIRST + VM.LUNCH + VM.DINNER ) AS MEALTOTAL

FROM T_PERSON P, T_DEPART D, T_SUBDEPART S, T_TITLE T,

( SELECT CE.COMPANYCODE, CE.PERSONID,

SUM( IIF( '063000' <= MID( CE.CARDEVENTDATE, 9, 6 ) AND MID( CE.CARDEVENTDATE, 9, 6 ) <= '093000', 1, 0 ) ) AS BREAKFIRST,

SUM( IIF( '110000' <= MID( CE.CARDEVENTDATE, 9, 6 ) AND MID( CE.CARDEVENTDATE, 9, 6 ) <= '140000', 1, 0 ) ) AS LUNCH,

SUM( IIF( '170000' <= MID( CE.CARDEVENTDATE, 9, 6 ) AND MID( CE.CARDEVENTDATE, 9, 6 ) <= '200000', 1, 0 ) ) AS DINNER

FROM T_CARDEVENT CE

WHERE CE.BOARDID = '02' // 식당은 보드 어드레스가 02 번이다.

AND CE.CARDEVENTDATE BETWEEN :STARTDATE AND :ENDDATE

GROUP BY CE.COMPANYCODE, CE.PERSONID

) VM

WHERE P.COMPANYCODE = '01'

AND P.COMPANYCODE = D.COMPANYCODE

AND P.DEPARTCODE = D.DEPARTCODE

AND P.COMPANYCODE = S.COMPANYCODE

AND P.DEPARTCODE = S.DEPARTCODE

AND P.SUBDEPARTCODE = S.SUBDEPARTCODE

AND P.COMPANYCODE = T.COMPANYCODE

AND P.TITLECODE = T.TITLECODE

AND P.COMPANYCODE = VM.COMPANYCODE

AND P.PERSONID = VM.PERSONID



AND MEALTOTAL > 0 => 이런식으로 하시면 될듯..



ORDER BY P.DEPARTCODE, P.TITLECODE, P.PERSONID



우리들 wrote:

> 강초입니다.

> dbgrid를 이용해서 조회하는 프로그램을 만들고 있습니다.

> dbgrid에 조회된 data들중에 금액이 0인것은 안나오게 할려고하는데

> 방법좀 알려주세요

> query로는 않되서 dbgrid에서 할려고 합니다.