CREATE VIEW dbo.IADE_CARI_LISTE
AS
SELECT        CODE, COMPANY, CITY, ARAMA, LOGICALREF
FROM            ((SELECT DISTINCT 
                                                     CODE, DEFINITION_ AS COMPANY, UPPER(CITY) AS CITY, CONCAT(CONCAT(DEFINITION_, ' - '), CODE) AS ARAMA, LOGICALREF
                            FROM            [UNIVERSALDB].[dbo].[LG_011_CLCARD] AS CC
                            WHERE        ACTIVE = 0)
                         UNION ALL
                         (SELECT DISTINCT 
                                                   CODE, [NAME] AS COMPANY, UPPER(CITY) AS CITY, CONCAT(CONCAT([NAME], ' - '), CODE) AS ARAMA, CLIENTREF AS LOGICALREF
                          FROM            [UNIVERSALDB].[dbo].[LG_011_SHIPINFO] AS SP)) QQ