pnvendor inv vendori 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.pnhow 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.