Novice SQL Question

From: Terry Lee Tucker <terry(at)esc1(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Novice SQL Question
Date: 2004-02-02 22:38:06
Message-ID: 200402021738.06828.terry@esc1.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I need to the following query:
select distinct event_code, level from logs join stat on (stat.prime is not
null) where order_num = 130680;

Ok, no problem. Does exactly what I want; however, I need to sort this is a
particular way to get the right results. When I try to add the order by
clause, I get an error. Here is the ORDER BY:
ORDER BY event_date DESC, event_time DESC, event_secs DESC

If I put this where I thought it should go as in:
select distinct event_code,level from logs join stat on (stat.prime is not
null) where order_num = 130680 order by event_date,event_time,event_secs;

I get the following error:
ERROR: For SELECT DISTINCT, ORDER BY expressions must appear in target list

No matter where I put it I get errors. Obviously, I'm a novice. Can somebody
give me any advice? I'm using Postgres 7.2.3 on RedHat.

Thanks...
--
Work: 1-336-372-6812
Cell: 1-336-363-4719
email: terry(at)esc1(dot)com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Terry Lee Tucker 2004-02-02 23:00:32 Re: Novice SQL Question
Previous Message Rod Taylor 2004-02-02 18:44:10 Re: Sometimes referential integrity seems not to work