join between three table with different table

[Poonamkumari]

Hi All,

I have three tables

FinanceMain has two field custid, finreference

finjointaccoutdetails has two field custcif, finreference

customers has two fields custid, custcif

i have used left join but not able fetch financemain data that is not present in finjointaccountdetails table. 

can someone help 

[Mark_Little]

Hi,

Can you supply you script.  Left Join will only keep from the right what exist in the left. 

Maybe just use the JOIN function and see if this gives you what you want.