Tim,


Tim Ledgerwood schrieb:

> Hi,
>
> What is the syntax for a select distinct query?
>
> I have a table that contains shift information. I want a query that will
> return me the shift number and shift date for shifts that contain valid
> information.
>
> SELECT DISTINCT(SHIFTNUM) FROM LOG WHERE (query parameters)
>
> Works fine - it gives me the shifts that I want.
>
> But
>
> SELECT DISTINCT(SHIFTNUM, DBDATE) doesn't work.

if you have more than one field in the DISTICT clause you've got to omit
the parenthesises.

So: SELECT DISTINCT SHIFTNUM, DBDATE

should work.

Luc.