Hi Elgin!
After of one Join you can do other Join, sample:
I have three table.
TableA -> Fields: CodA, NameA.
TableB -> Fields: CodA, CodB, NameB.
TableC -> Fields: CodB, CodC, NameC.
My Select:
Select A.CodA, A.NameA, B.CodB, B.NameB, C.CodC, C.NameC ;
From TableA As A Inner Join TableB As B On A.CodA = B.CodA Left Join ;
TableC On B.CodB = C.CodB ;
Order By A.NameA, B.NameB, C.NameC
Good Luck!
Bye!
Erick
Força Sempre!
Strength Always!