Fuzzy matching required for exact match

Hi   I have 2 tables. Table A has a relationship with Table B using an ID in the standard way.   Lets' say both have 150 rows and it's a 1:1 relationship.   When I do a direct query in SQL    ...