I have applied merge queries with left outer join between employeeEmail column of two tables but it returns 0 matching rows.
I have matching values in both the tables,then why is it returning 0 rows?
Go to Solution.
Actually the values in one table was in uppercase and in other it was lowercase,once i changed both to lowercase it works.
Are the data types of the columns you match on the same, this might explain your issue.