LOGO CARI BAKIYELER SQL SORGU

CREATE VIEW ZV_CARI_BAKIYELER AS
SELECT
* ,
CASE WHEN C.BAKIYE>RISK AND RISK>0 THEN 'SATMA' ELSE 'SAT' END KONTROL
 FROM ( SELECT
CLCARD.LOGICALREF, CLCARD.CODE AS CARI_KOD, CLCARD.DEFINITION_ AS CARI_AD,
CONVERT(DECIMAL(10),(SUM((1-CLFLINE.SIGN) * CLFLINE.AMOUNT) - SUM(CLFLINE.SIGN * CLFLINE.AMOUNT)) ) AS [BAKIYE],
ISNULL((select ACCRISKLIMIT from LG_{0}_01_CLRNUMS WHERE CLCARDREF = CLCARD.LOGICALREF),0) RISK
 FROM

LG_{0}_01_CLFLINE CLFLINE INNER JOIN
LG_{0}_CLCARD CLCARD ON CLFLINE.CLIENTREF = CLCARD.LOGICALREF AND CLFLINE.CANCELLED = 0 AND CLCARD.SPECODE<>''
GROUP BY CLCARD.LOGICALREF, CLCARD.CODE, CLCARD.DEFINITION_, CLCARD.ACTIVE
HAVING   (CLCARD.ACTIVE = 0)
) AS C