Hi friends,
I want to know How to create view from multiple table in sql server ? And What is advantages with example.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
SenthilkumarPosted May 14, 2012, 7:11 AM
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 kPosted May 13, 2012, 3:29 AM
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