I have two tables, one with 110,100 rows, and the other with 89,545 for a combined 199,645.

When I do a UNION query, I only get 199,614 rows.

To try and find the 31 missing rows, I've tried both INTERSECT and joins, but can't turn up any results for the apparently 31 duplicate rows. Shouldn't I get the 31 rows by substituting union with intersect??