Let me start by naming my two tables: My first table is Table2 second is LookupTbl2 I have a weird situation that I need some help on. So Table2 joins to LookupTb12 to map certain terms. Now about 90% of the values map correctly. They other 10% show NULL after I join them. The terms match exactly in both tables (spaces and all): How can this be I am assuming they have different BinaryValues somehow Any ideas how to resolve this?
I seem to have found the issue...I was importing a tab delimited file and the terms that were troublesome were spread across multiple lines of the file. Once I corrected this in the import file Everything worked correctly. Although it was a pain going through that whole file.