I have a mysql table looks like this ...
address_id bigint(11) AUTO_INCREMENT
Each family (family_id) has two addresses.
A Service and Mailing (type enum)
That means each family should have two address_id's.
(Should also be sequential bc the data is always entered two rows @ a time. The service add & mail add)
My issue that there are 23054 distinct family id's, but there are only 46080 addresses entered. (by count, not address id).
There should be 46108 if there were two rows for each id.
How can I run a report that will tell me every family id, or address_id that belongs to a row where the family id in that rows has anything but 2 rows entered .. ??