Thanks Marek, That put me right on track :) Justin
on 23/01/03 11:24 PM, Marek Kilimajer ([EMAIL PROTECTED]) 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php