Table contains 100 records and View contains 200 records (both the structures are same). How to get 300 records by using SQL Command
select column1,column2 from table
union
select column1,column2 from view
You might need to use UNION ALL
Table contains 100 records and View contains 200 records (both the structures are same). How to get 300 records by using SQL Command
select column1,column2 from table
union
select column1,column2 from view
You might need to use UNION ALL