hello everybody

i have 3 tables i need to join

pnvendor
inv
vendor

i am able to join the first 2 tables

sele a.pn ;
   from pnvendor a left join inv b on a.pn = b.pn ;
   where ;
      "1004" $ a.vendorid .and. ;
      "04AV205" $ a.pn

how do i add the 3rd table. the 3rd table (vendor) needs to be joint to the 1st table (pnvendor) on the vendorid field in the same way the 1st and the 2nd table are joint.

thank for all your help as always!