Re: Locating Primary records with identical detail records

I'm with Charles on this one. We're confused. Are you saying that
FUNCTIONS may be the same (for example 'X') in ID 105 and ID 217 but they
may still not be the same because you then have to evaluate other columns
in the rows to see if they are similar or different? How many columns are
in the table? What columns can be different versus those that must be the
same (as to define duplicate)?

Let's say that ID can be different. FUNCTIONS must be the same. Columns
A, B, C must be the same. Columns D, E and F could be different. You
could do something like

Select M.*, D.*
from master m left outer join detail d on (m.id=d.id)
where d.functions, d.a, d.b, d.c in (
select e.functions, e.a, e.b, e.c
from detail e
group by e.functions, e.a, e.b, e.c
having count(*)>1)
order by d.functions, d.a, d.b, d.c, d.id


Rob Berendt