CREATE VIEW dbo.S1SINTESI
AS
SELECT     controvalore, RETE, 'ALTRO' AS descrizione
FROM         dbo.S1ALTRO
UNION
SELECT     controvalore, RETE, 'BF' AS descrizione
FROM         dbo.S1BF
UNION
SELECT     controvalore, RETE, 'IMMOBILIARE' AS DESCRIZIONE
FROM         dbo.S1IMMOBILIARE
UNION
SELECT     controvalore, RETE, 'TERZI' AS DESCRIZIONE
FROM         dbo.S1TERZI