Re: URGENT: sql group by clause has stopped working

try

select owner
from smith
where job = 'comp'
and branch = '9'
group by owner
having count(owner) > 1;

The HAVING clause is useful in determining dupes.

Have Fun

--

Posted via dBforums\nhttp://dbforums.com