Irregular Results From JOIN

[mcfly1204]

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.C ONTACTID

Given CONTACTID is the PK for each table, what am I doing wrong here?

[code green]

if there are 102 matching IDs but only 75 are returned
it is probably the IDs have acquired extra spaces.
Use RTRIM. LTRIM

[mcfly1204]

if there are 102 matching IDs but only 75 are returned
it is probably the IDs have acquired extra spaces.
Use RTRIM. LTRIM

I appreciate the response, but given the values in TableB came directly from TableA, there is not a chance of extra spaces being added.

[ck9663]

Is there a NULL value on your CONTACTID? I assume it's the primary key. Try doing a left join and see what the query returns.

-- CK

[Delerna]

Hi
I am assuming the fields are character fields because extra spaces are mentioned

given the values in TableB came directly from TableA, there is not a chance of extra spaces being added.

Umm, there is a chance
If the field in tableA is varchar and the field in tableB is char then there could be extra spaces added to the fields in tableB even though it's records came directly from tableA

Could this be the case?

Looking at your query I cannot see anything that you are doing wrong!
So it suggests a field type mismatch of some sort
Regards