Content-Type: text/plain;
  charset="us-ascii"
From: Terry Lee Tucker <terry@esc1.com>
Organization: Enhanced Solutions Computing
To: pgsql-sql@postgresql.org
Subject: Novice SQL Question
Date: Mon, 2 Feb 2004 17:38:06 -0500
User-Agent: KMail/1.4.1
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200402021738.06828.terry@esc1.com>

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

Ok, no problem. Does exactly what I want; however, I need to sort this is a=
=20
particular way to get the right results. When I try to add the order by=20
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=
=20
null) where order_num =3D 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 somebod=
y=20
give me any advice? I'm using Postgres 7.2.3 on RedHat.

Thanks...
--=20
 Work: 1-336-372-6812
 Cell: 1-336-363-4719
email: terry@esc1.com