Display data from multiple tables in View in SQL Server

Hi LoganTRK,

Please refer below query-

SQL

CREATE TABLE  Table1 (Code INT, Ruler VARCHAR(10))
CREATE TABLE  Table2 (Code INT, Ruler VARCHAR(10))
CREATE TABLE  Table3 (Code INT, Ruler VARCHAR(10))
INSERT INTO Table1 VALUES(1,'ok')
INSERT INTO Table2 VALUES(1,'ok')
INSERT INTO Table3 VALUES(1,'ok')
 
ALTER VIEW ViewTable AS
Select 'Table1' as 'TABLES',Table1.Ruler, Table1.Code FROM Table1 WHERE Table1.Ruler = 'OK'
UNION ALL
Select 'Table2' as 'TABLES',Table2.Ruler, Table2.Code FROM Table2  WHERE Table2.Ruler = 'OK'
UNION ALL
Select 'Table3' as 'TABLES',Table3.Ruler, Table3.Code FROM Table3 WHERE Table3.Ruler = 'OK'
 
SELECT * FROM ViewTable

Output