I am trying to find duplicate spousess.
I created the following query:
(select n1.surname || “, ” || n1.given from nametable n1 where fatherid = ownerid) as fathername,
(select n2.surname || “, ” || n2.given from nametable n2 where motherid = ownerid) as mothername
order by fatherid, motherid;
1. Should there be blank fatherid’s for a motherid in the result?
2. Or likewise blank motherids for a fatherid in the results?
3. Am I safe to think that if there are 2 motherid’s for the same fatherid that it is a duplicate?