Hello Sergey

i tried your recomandation. The result querry should have 2 records. but that solution i get a lot more dublicated (i think because in pnvendor are a bunch of entries for that 1 vendor). i can resolve it with "distinct". would that be the only solution?

Thanks for your help

>See inline.
>
>>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 ;
>     LEFT JOIN vendor v on v.vendorid = a.vendorid ;
>>   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!