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!