SQLTeam.com | Weblogs | Forums

How to create one table by using all the data from 4 tables?


#1

How do put all the data form all the columns from 4 tables into one? what is the syntax for that?


#2

You could create a view?

CREATE VIEW MyViewName
AS
SELECT A.Col1, A.Col2,
       B.ColX, B.ColY,
       ...
FROM TableA AS A
     JOIN TableB AS B
         ON B.SomeID = A.SomeID
     JOIN TableC AS C
         ...