ms sql query

[taproot9]

SELECT cidate,
cinum,
cicustomername,
SUM(cidamt) as cigrsamt,

CASE
WHEN ciisforeign=1
THEN SUM(cidamt)*.2
ELSE SUM(cidamt)*.1
END as cilesscpa,

CASE
WHEN ciiszerorated=0
THEN SUM(cidamt)*.12
ELSE 0
END as civat,

ciiszerorated,
ciisforeign

FROM tblcidetail LEFT JOIN tblcimaster ON cidnum = cinum

WHERE cidcontdesc like 'OVERWEIGHT%'
AND cidate between '9/24/2015'
and '9/24/2017'
AND ciiscancel = 0

GROUP BY cinum
ORDER BY cidate ASC


pa help naman mga master.. thank you

 

[jhefreyzz]

ano ba ang problema mo?
kung magpapatulong ka sana lagyan mo ng details wag mo lang ilagay yung query?
hindi ka matutulungan kung ganyan lang nilagay mo.
ano gusto mong gawin?