multiple joins

[Atrix Wolfe]

hello, im tryin to do another sql query but cant seem to get it working...   heres whats up, the names have been changed to protect the innocent (;   i have a main table 'TableA' with 2 id fields...IDB and IDC.  I have 2 other tables..TableB and TableC.  What i need to do is left join TableA with both those tables while also limiting IDA to a specific value.  Simplified i need to look up some rows in tableA and then grab the data from TableB using those IDB's in TableA and do the same with TableC and the IDC's in TableB.  I cant seem to get it to work in a single statement...   this is the closest i got but it isnt workin ):   select * from TableA left join TableB on TableA.IDB=TableB.IDB left join TableC on TableA.IDC=TableB.IDC where TableA.IDA=435   is something like this doable?