"André Medeiros" <andre.caum@xxxxxxxxx> wrote in message news:1122379553.3499.14.camel@xxxxxxx > One thing I didn't quite explain myself well... I'm building this to > register objects on a permission system. > > The SQL weight is heavy as it is, and I want to save queries as much as > possible. Making two queries to extract information about a project and > it's parent is not something I'd want to do. I know recursiveness, but > thanks for the pointers and for the reply :) > > Best regards I must admit I still don't really get what you are looking for. Does this query help? select c.field1 AS childfield1, c.field2 AS childfield2, (etc) p.field1 AS parentfield1, p.field2 AS parentfield2, (etc) FROM child AS c LEFT JOIN parent AS p ON c.parent=p.id ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
