0 match when merging 2 queries

[cristitoma]

Do you guys know why this left outer join gives 0 matches even though i have checked the data types, plus there is for sure a surrogate key.

[MattAllington · Accepted solution]

Have you checked for spaces and non pro ting characters on both columns?  There are some menu options to trim and clean. 

[cristitoma]

Thanks Matt, that worked.