October 28, 2008 at 11:10 am
I need to link 2 tables; table A and Table C.
But the only way to do that is using a 3rd table, table B.
Here are the Ids I need to link up:
tableA contains appleId
tableB contains appleId and fruitId
TableC contains fruitId
And here is my query...does this look like a good way of doing this?
SELECT at.appleId, at.appleName, bt.fruitId, bt.processTitle, ct.fruitId,
ct.farmId, ct.farmText
FROM TableA at
LEFT JOIN TableB bt ON bt.appleId = at.appleId
LEFT JOIN TableC ct ON ct.fruitId = bt.fruitId
Thanks!
Magy
October 28, 2008 at 11:35 am
Yeah, that's a pretty standard many-to-many relationship.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 28, 2008 at 12:59 pm
The only thing I would add would be to make sure the joins are correct. Using outer joins (LEFT) will return all rows from TableA and only matching items from TableB/C (I am assuming that there cannot be entries in TableB that don't have matching rows in TableA and TableC).
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply