Joining many tables together using key from first table for all joins?

Question

I would like to do something like this but can't get it to work:

SELECT A.*,B.*,C.* FROM tableA A LEFT JOIN
B ON A.ID = B.ID
C ON A.ID = C.ID

I.e. I need to use a field from the first table for all joins as tableB and tableC don't has any fields to link them together.

Can this be done?

score 2 · Accepted Answer · answered Jun 10 '13 at 13:04

2

you missed a join !

SELECT A.*,B.*,C.* FROM tableA A 
LEFT JOIN
B ON A.ID = B.ID
left join
C ON A.ID = C.ID

answered Jun 10 '13 at 13:04

Ian Kenney

Thanks. I got it to work. I had missed to type in tableC between JOIN and ON. – Lars Ljungberg Jun 10 '13 at 13:38

score 0 · Answer 2 · answered Jun 10 '13 at 13:11

0

Try this one -

SELECT * 
FROM dbo.tableA A 
LEFT JOIN dbo.B ON A.ID = B.ID
LEFT JOIN dbo.C ON A.ID = C.ID

answered Jun 10 '13 at 13:11

Devart

2 Answers2