MySQL Forums
Forum List  »  Newbie

Re: Query advice - Multiple LEFT JOINS to same table or not??
Posted by: Joby Tyler
Date: March 24, 2005 10:54AM

yeah - its a tricky decision - Thinking about it again, I think i'll need 13 left joins because I start with a pair table - with a left join to get the pigeon details in the pair. For each of the 2 pigeons in the pair, i need 2 more left joins to the pigeon table to get the parents details. Then from each of those 2 parents I need 2 more left joins to get the parents parents details.

I guess it would seem neater if I can get it all in one query, without peppering the PHP with single record queries - I suppose its a question of which will perform better too.........have no clue there without writing both and giving them a go.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.