Re: nested queries/loops
| From: | Justin French | Date: | Thu, 23 Jan 2003 13:18:42 +0000 |
| Subject: | Re: nested queries/loops | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-132815@lists.php.net to get a copy of this message | ||
Thanks Marek, That put me right on track :)
Justin
on 23/01/03 11:24 PM, Marek Kilimajer (kilimajer@webglobe.sk) wrote:
> SELECT * FROM partner p LEFT JOIN pid_to_sid p2s ON p.id=p2s.pid LEFT
> JOIN service s ON p2s.sid=s.id LEFT JOIN category c ON s.categoryid=c.id
> WHERE $your_conditions ORDER BY p.name, c.name, s.name