Обсуждение: Duplicate information in parent and child tables

Поиск
Список
Период
Сортировка

Duplicate information in parent and child tables

От
JORGE MALDONADO
Дата:
I have a parent table and a child table. In order to detect duplicate information I need to consider both tables. This means that a "duplicate record" consists of one parent record and one or more child records. 
Is there any standard approach to solve this issue?

Respectfully,
Jorge Maldonado

Re: Duplicate information in parent and child tables

От
msi77
Дата:
Maybe this will help http://sql-ex.ru/help/select18.php

04.04.2012, 02:03, "JORGE MALDONADO" <jorgemal1960@gmail.com>:
> I have a parent table and a child table. In order to detect duplicate information I need to consider both tables.
Thismeans that a "duplicate record" consists of one parent record and one or more child records.  Is there any standard
approachto solve this issue? 
>
> Respectfully,
> Jorge Maldonado