CREATE VIEW dbo.SATINALMA_FATURALARI
AS
SELECT   CAST(INV.DATE_ AS DATE) AS DATE_, INV.FICHENO, INV.LOGICALREF, CC.CODE, CC.DEFINITION_, CC.CITY
FROM         dbo.LG_011_08_INVOICE AS INV LEFT OUTER JOIN
                         dbo.LG_011_CLCARD AS CC ON CC.LOGICALREF = INV.CLIENTREF
WHERE     (INV.TRCODE = 1) AND (INV.CANCELLED = 0)