TABLE JOINING PROBLEM - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

TABLE JOINING PROBLEM

Author

Topic

sql_learner
Starting Member

7 Posts

Posted - 2002-08-14 : 00:19:16

I have these 3 tables

Table 1
ID Tab1Val
1 Val1
2 Val2
3 Val3

Table 2
ID Tab2Val
1 Val1
3 Val3

Table 3
ID Tab3Val
2 Val2
3 Val3

How can I join them to get the table below

ID Tab1Data Tab2Data Tab3Data
1 Val1 Val1 NULL
2 Val2 NULL Val2
3 Val3 Val3 Val3

I have tried to use LEFT OUTER JOIN on these 3 tables with JOIN CONDITION on ID but i did not work. Pls HELP!!!

Edited by - sql_learner on 08/14/2002 00:22:25

nr
SQLTeam MVY

12543 Posts

Posted - 2002-08-14 : 04:01:10

if tbl1 has all entries
select tbl1.val, tbl2.val, tbl3.val
from tbl1
left outer join tbl2 on tbl1.id = tbl2.id
left outer join tbl3 on tbl1.id = tbl3.id

if tbl1 doesn't

select tbl1.val, tbl2.val, tbl3.val
from
(select id union select id union select id from tbl3) as tbl
left outer join tbl1 on tbl.id = tbl1.id
left outer join tbl2 on tbl.id = tbl2.id
left outer join tbl3 on tbl.id = tbl3.id

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

sql_learner
Starting Member

7 Posts

Posted - 2002-08-14 : 04:06:07

Well, I have worked out this problem with a FULL OUTER JOIN on Table1.ID = Table2.ID AND Table1.ID = Table3.ID
Thanks ALL anyway

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources