Forum Discussion
Anonymous
9 years agoNot applicable
0 match when merging 2 queries
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.
Have you checked for spaces and non pro ting characters on both columns? There are some menu options to trim and clean.
2 Replies
- MattAllingtonCommunity Champion
Have you checked for spaces and non pro ting characters on both columns? There are some menu options to trim and clean.
- AnonymousNot applicable
Thanks Matt, that worked. :smileyhappy: