ISNULL(SUM(CASE WHEN TRCODE IN(8) YARDIM

[aahmetkurtt]

SELECT ISNULL(SUM(CASE WHEN TRCODE IN( THEN LG_005_01_STLINE.TOTAL-LG_005_01_STLINE.DISTCOST END),0)  FROM LG_005_01_STLINE,LG_005_CLCARD,LG_005_ITEMS    WHERE LG_005_CLCARD.LOGICALREF=LG_005_01_STLINE.CLIENTREF    AND LG_005_ITEMS.LOGICALREF=LG_005_01_STLINE.STOCKREF    AND LG_005_CLCARD.CODE BETWEEN '0100'  AND '2958'    AND LG_005_ITEMS.CODE BETWEEN '0001'  AND '0313'   AND LG_005_01_STLINE.DATE_ BETWEEN '01/04/2008'  AND '30/04/2008' 

ISNULL(SUM(CASE WHEN TRCODE IN( BURDA TRCODE TÜRÜNÜ SATIŞ OLARAK
SEÇEBİLİYORUM BENİM YAPMAK İSTEGİMİ TRCODE YERİNE
CLCARD.CODE>='0100' AND CLCARD.CODE<='0399' GİBİ FİLİTRE UYGULAYABİLİRMİYİM.

YANİ BÖYLE BİR ŞEY YAPMAK İSTİYORUM ( ISNULL(SUM(CASE WHEN CLCARD.CODE (BETWEEN '0100' AND '0399') MÜMKÜNMÜDÜR ACABA

[MehmetYavuz]

case when CLCARD.CODE between '0100' AND '0399' then blablabla else blabla end

şeklinde kullanabilirsiniz

[aahmetkurtt]

YARDIMLARINIZ İÇİN ÇOK TŞK. EDERİM
SAOLUN
İŞE YARADI