Le mardi 08 mars 2005 à 12:29 +0100, Martijn van Oosterhout a écrit : > and, does it work? Obviously you need to put the joins in and such. But > the outer query should be last, like: > > SELECT * FROM > (... subquery ...) AS x > ORDER BY name; > > The outer query is only for ordering, the joins, etc should all be in > the subquery... You are my man!!!!! Thanks for that Beer =:-D Tony ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)