SQLTeam.com | Weblogs | Forums

Sql retrieve command


#1

Table contains 100 records and View contains 200 records (both the structures are same). How to get 300 records by using SQL Command


#2

select column1,column2 from table
union
select column1,column2 from view


#3

You might need to use UNION ALL