Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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

  • MattAllington's avatar
    MattAllington
    Community Champion

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks Matt, that worked. :smileyhappy: