How to write a view in sql server 2012

Question

how to write a view to show data of two table

Raja T · Answer

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://stackoverflow.com/questions/3267360/data-from-two-tables-into-one-view https://technet.microsoft.com/en-us/library/ms187956(v=sql.110).aspx http://www.dbtalks.com/UploadFile/c37c73/concepts-of-create-view-from-multiple-table-in-sql-server/

Khan Abrar Ahmed · Answer

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