On Tue, Mar 08, 2005 at 12:22:35PM +0100, tony wrote: > Le mardi 08 mars 2005 à 11:04 +0100, Martijn van Oosterhout a écrit : > > You can put the DISTINCT ON() query as a subquery, and an ORDER BY in > > the outer query. > > That was my first guess > > select number.inventorynumber, name, first_name > from (select distinct on (inventorynumber) inventorynumber from works) > as number, artist, blah > order by name 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... -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
Attachment:
pgpLEF5i7lFN9.pgp
Description: PGP signature
