CREATE VIEW dbo.RETURN_FORM_DRAFT_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(LOGOGO,'') AS LOGOGO
FROM [UNIVERSALDB].[dbo].[RETURN_FORM] AS RF LEFT OUTER JOIN 
LG_011_CLCARD AS CC ON CC.LOGICALREF = RF.CLIENTREF
WHERE RF.[DEL]=0 AND RF.[DRAFT]=1