CREATE VIEW dbo.HATALI_PLASIYER_GIRISLERI
AS
SELECT   *
FROM         ((SELECT   REPLACE(REPLACE(CASE WHEN CHARINDEX(' ', SLS.DEFINITION_) = 0 THEN SLS.DEFINITION_ ELSE LEFT(SLS.DEFINITION_, CHARINDEX(' ', SLS.DEFINITION_)) END, ' ', ''), 
                                                      'G', 'G') AS 'HATALI', REPLACE(CC.SPECODE2, 'G', 'G') AS 'DOGRU', CC.DEFINITION_ AS 'FIRMA', UPPER(CC.CITY) AS 'SEHIR', CLF.DATE_ AS 'TARIH', 
                                                      CLF.TRANNO AS 'FISNO', CLF.TRNET AS TUTAR
                            FROM         LG_011_08_CLFLINE AS CLF LEFT OUTER JOIN
                                                      LG_011_CLCARD AS CC ON CC.LOGICALREF = CLF.CLIENTREF LEFT OUTER JOIN
                                                      LG_SLSMAN AS SLS ON SLS.LOGICALREF = CLF.SALESMANREF
                            WHERE     SLS.DEFINITION_ IS NOT NULL)) QQ
WHERE     QQ.HATALI <> QQ.DOGRU AND QQ.DOGRU <> ''