I have table A which has 202 unique record and table B which has 102 unique records. The 102 values in table B came from table A, so there are 100 other records in table A. However, the following query only returns 75 rows:
SELECT *
FROM TableA A JOIN
TableB B ON B.CONTACTID=A.CONTACTID
Given CONTACTID is the PK for each table, what am I doing wrong here?