Combining multiple small T-SQL queries

Question

I am trying to get data from a table that is identified by ID's from other tables; they all feed into each other. For example:

Get tblA.ID
Using tblA.ID, get tblB.ID
Using tblB.ID, get tblC.ID
Using tblC.ID, get tblD.Username

So I would begin with:

SELECT [ID]
FROM tblA
WHERE [Name] = 'Joe Bloggs'

But how would I continue the trail?

Sounds like you need to use a JOIN. - technet.microsoft.com/en-us/library/ms191517(v=sql.105).aspx — Darren
– Darren, Commented Nov 7, 2013 at 14:18

NL - SE listen to your users · Accepted Answer · 2013-11-07 14:27:34Z

1

SELECT Username 
FROM tblD 
JOIN tblC ON tblC.ID = tblD.ID
JOIN tblB ON tblB.ID = tblC.ID
JOIN tblA ON tblA.ID = tblB.ID

Presumably you would use other columns joining each of the tables together, but this follows your example as closely as possible.

answered Nov 7, 2013 at 14:27

51311 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1