Good day
=-\==\=\=-\-=\
Wont a group by be the answer here ?

select shiftnum,dbdate from log
where (where stuff)
group by shiftnum,dbdate

This , I believe will help

Hope this helps

Johannes


At 10:36 29/06/2004, you wrote:

>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.
>
>Nor does
>
>SELECT DISTINCT(SHIFTNUM), DBDATE
>
>How can I solve this?
>
>Regards
>
>Tim
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.712 / Virus Database: 468 - Release Date: 27/06/2004

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.712 / Virus Database: 468 - Release Date: 27/06/2004


[Non-text portions of this message have been removed]