Im looking for a SQL query or Crystal Reports solution that will allow me to develop and show only those records that are duplicated in our document table in SQL2000 that have the same jobid but different filenames for an exception report.

Any advice would be greatly appreciated.

Thanks,

mking

select jobid, filename from table1
group by jobid, filename
having count(*) > 1