How do put all the data form all the columns from 4 tables into one? what is the syntax for that?
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
...