Re: Query advice - Multiple LEFT JOINS to same table or not??
You could do it with a stored procedure in MySQL 5, but it's alpha. Anyway... you can't recursively select to an unknown depth. If you knew how many parents you needed to select you could code it for that number of parents, though - you could add a depth column and use that to calculate how many joins your query would need. Either way you'll have to do some PHP stuff to pull it off.
Subject
Written By
Posted
Re: Query advice - Multiple LEFT JOINS to same table or not??
March 24, 2005 08:27AM
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.