CREATE VIEW dbo.RETURN_FORM_LIST
AS
SELECT        RF.DATE_ AS TARIH, RF.TIME_ AS ZAMAN, RF.FICHENO AS FISNO, CC.CODE AS FCODE, CC.DEFINITION_ AS FUNVAN, UPPER(CC.CITY) AS CITY, CC.SPECODE2 AS PLAS, RF.DESCRIPTION_ AS DESCR, RF.DATETIME_ AS TZ, 
                         ISNULL(RF.LOGOGO, '') AS LOGOGO, RF.DRAFT, RF.REF, CC.LOGICALREF, RF.TYPE_, RF.BCOLOR, RF.KILIT
FROM            dbo.RETURN_FORM AS RF LEFT OUTER JOIN
                         dbo.LG_011_CLCARD AS CC ON CC.LOGICALREF = RF.CLIENTREF
WHERE        (RF.DEL = 0)