parent table (p) has 569,275 records and child table (c) has 633,283
select count(*) from parent -- 569,275
select count(*) from child -- 633,283
All parents have at least 1 child
select p.* FROM [parent] p where p.pID in (select cid from child) -- 569,275 matches parent count
Why...