How to write a view in sql server 2012

Hi,

 

 

CREATE VIEW vw_combined

 AS

 SELECT * FROM TABLE1 

   UNION ALL

 SELECT * FROM TABLE2

 

or

 

CREATE VIEW vw_combined

 AS 

SELECT * FROM TABLE1 t1  

 JOIN TABLE2 t2 ON t2.col = t1.col

more details checkout bellow urls

 

 

 

http://www.dbtalks.com/UploadFile/c37c73/concepts-of-create-view-from-multiple-table-in-sql-server/ 

Hi refer this links

 

https://msdn.microsoft.com/en-us/library/ms187956.aspx

https://msdn.microsoft.com/en-us/library/ms175503.aspx

http://www.w3schools.com/sql/sql_view.asp