Create View From Multiple Table in Sql Server

Question

Hi friends I want to know How to create view from multiple table in sql server ? And What is advantages with example.

Senthilkumar · Answer

Hi Ajay When you write the complex joins in the sql server statement same can be applied into the views with view creation statement. It can't update the data because it is underlying into multiple statement.

brunda k · Answer

Table 1 - Geography Table2 - Store_Information CREATE VIEW V_REGION_SALES AS SELECT A1.region_name REGION SUM(A2.Sales) SALES FROM Geography A1 Store_Information A2 WHERE A1.store_name = A2.store_name GROUP BY A1.region_name http://sqlserverpedia.com/wiki/Views_-_Advantages_and_Disadvantages