Posted by markc600 on 05/04/06 17:00

You don't appear to have any criteria for
the one row you want if there are more than one.
If that's the case and log_id is unique, this should work

select max(log_id),cust_id,type,service_id
from log
group by cust_id,type,service_id

• Next in forum: how to find conditions across rows (attendance)
• Prev in forum: Re: Gather Format and Store - Right or Wrong
• Thread view: Re: help for query

[Reply to this message]