sql sorguda hata

[erhan2484]

merhaba,aşağıda yazdığım sorgu çalışmıyor.nasıl düzenlemeliyim

SELECT C2.CODE,
(0.4 * (SELECT  R.ACCRISKLIMIT FROM LG_039_CLCARD C1,LG_039_01_CLRNUMS R
WHERE C1.LOGICALREF=R.CLCARDREF AND
C1.CODE NOT LIKE ('X%')
AND C1.CODE NOT LIKE ('ŞA%') AND C1.CODE NOT LIKE ('Y%') AND C1.ACTIVE=0 )) LİMİT
FROM LG_039_CLCARD C2,LG_039_CLCARD C3 WHERE C2.DEFINITION_=C3.DEFINITION_ AND C2.CODE LIKE '%Ö'

[Yazar]

Yazılar