Combine columns from multiple tables into one

Grant beat me to it but I believe you are simply wanting to LEFT JOIN all of your tables ...

SELECT T1.ComputerName, T1.Data, T2.Data, T3.Data, T4.Data
FROM #TMP1 T1
LEFT JOIN #TMP2 T2
 ON T1.ComputerName = T2.ComputerName
LEFT JOIN #TMP3 T3
 ON T1.ComputerName = T3.ComputerName
LEFT JOIN #TMP4 T4
 ON T1.ComputerName = T4.ComputerName

... will result in the following output ...

ComputerName     Data             Data             Data             Data
---------------- ---------------- ---------------- ---------------- ----------------
PC1              AAA              111              NULL             aaa
PC2              BBB              NULL             ###              bbb
PC3              CCC              222              NULL             ccc
PC4              DDD              NULL             $$$              ddd
PC5              EEE              333              NULL             eee

If your initial table does not have all the computer names in it you could either get a distinct list on the fly (as in the example below), create another table that has all the computer names and use it as your primary SELECT FROM table, or possible create a SQL View that is the equivalent to my "on the fly method".

SELECT C.ComputerName, T1.Data, T2.Data, T3.Data, T4.Data
FROM ( SELECT DISTINCT ComputerName FROM #TMP1
       UNION
       SELECT DISTINCT ComputerName FROM #TMP2
       UNION
       SELECT DISTINCT ComputerName FROM #TMP3
       UNION
       SELECT DISTINCT ComputerName FROM #TMP4 ) C                  
LEFT JOIN    #TMP1 T1
 ON C.ComputerName = T1.ComputerName
LEFT JOIN    #TMP2 T2
 ON C.ComputerName = T2.ComputerName
LEFT JOIN #TMP3 T3
 ON C.ComputerName = T3.ComputerName
LEFT JOIN #TMP4 T4
 ON C.ComputerName = T4.ComputerName

I'm a little confused by what you mean you say "put these tables together" but I think you're looking for one of two things. Either, you want to combine the results of all the tables, all at once, in which case you need to use the UNION or UNION ALL operator like this:

SELECT *
FROM tab1
UNION ALL
SELECT *
FROM Tab2
--etc.

This will put all these tables into a single result set. In this case I used UNION ALL, which just does a straight combination. If you just put in UNION, then you get a unique set of data, eliminating duplicates.

Or, you're trying to combine all the tables to get common data out of them, something like this:

SELECT *
FROM Tab1
JOIN Tab2
ON Tab1.ComputerName = Tab2.ComputerName

But I'm not sure that's what you mean.

From what I gather, you should just be able to change the join to a full join in Grant's example (expanded to include all of your tables of course.). This article on MSDN may help: http://msdn.microsoft.com/en-us/library/ms187518.aspx

Hi, i want to retrieve my vtype_id and vtype_desc from 5 tables to view the activities of last 7 days on the basis of datediff. and my all table are having vtype_id. and also want to make it a union also. so pleaase tell me how to do. plz make it fast i have to submit my project 2day.

update Table1 Set (Select Column1 From Table1 Where ColumnID1=Table1.ColumnID1)='11', (Select Column2 From Table2 Where ColumnID2=Table1.ColumnID1)='22' Where Table1.ColumnId1=1