How to create view from more than one table in MS Sql Server database?

Question

I have to create a view from more than one table in MS Sql Server database, but i am not able to get the correct syntax for the same. need help.

thanks.

Answer 1

You'll have to provide more information about how you are looking to return data from more than one table. Typically you use JOINs:

CREATE VIEW your_view_vw AS
   SELECT *
     FROM TABLE_A a
     JOIN TABLE_B b ON b.pk = a.fk

...where fk stands for "Foreign Key", and pk stands for "Primary Key" - assuming these constraints are in place. Maybe you need to use a Cross join instead? Here's a great visual representation of JOINs visually.

Reference:

• CREATE VIEW

Answer 2

You do this with JOINs, just like you would with a regular query.

If you can write a query that gets you the data, you should be able to write view nearly the exact same way.

Post what you have.

Answer 3

example

create view ViewCustomerOrders
as
select * from Customer c
join Order o on o.CustomerID = c.CustomerID 

Answer 4

Show us what you have already...