Triple joins? Possible?

[Anon]

I know that I can do ...

select * from testtable LEFT JOIN anothertable ON
testtable.testtablekey=anothertable.anothertablekey

for a 1 to 1 relationship...

I need to do a 1 to 2 relation with the SAME key field.

any help is appreciated.

Fritz

[Anon]

select * from table1 left join table2 on table1.key=table2.key left join table3 on table1.key=table3.key

[Anon]

Hi!

I have four joins and it works very fast:

SELECT DISTINCTROW tblProAssociations.LogoLink,
tblProAssociations.$assoc_header

FROM (((tblExhibitions 
LEFT JOIN jnExhibitions2Base ON (tblExhibitions.MainExhID = jnExhibitions2Base.ExhibitionID)) 
LEFT JOIN tblBaseExhibitions ON (jnExhibitions2Base.BaseExhibitionID = tblBaseExhibitions.MainExhID)) 
LEFT JOIN jnExhibitions2Assoc ON (tblBaseExhibitions.MainExhID = jnExhibitions2Assoc.BaseExhID)) 
LEFT JOIN tblProAssociations ON (jnExhibitions2Assoc.AssociationID = tblProAssociations.AssociationID) 

WHERE $exh_condition AND tblProAssociations.LogoLink IS NOT NULL 
ORDER BY tblProAssociations.$assoc_header;

Hope this helps,
Stas