On Thu, 07 Nov 2002 09:57:27 +0100 Christoph Haller <[EMAIL PROTECTED]> wrote:
> > ORDER BY proj.project_id ; > > What about simply replacing ORDER BY proj.project_id ; by > GROUP BY project_id, marketing_name ; You're right. Thanks a lot. Regards, Masaru Sugawara ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html