cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jatneerjat Member
Member

merge queries not working

Hi,

 

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?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
jatneerjat Member
Member

Re: merge queries not working

Hi @MauriceMecowe,

 

Actually the values in one table was in uppercase and in other it was lowercase,once i changed both to lowercase it works.

 

Thanks,

Neeraj

 

2 REPLIES 2
MauriceMecowe Regular Visitor
Regular Visitor

Re: merge queries not working

Hi @jatneerjat

 

Are the data types of the columns you match on the same, this might explain your issue.

Highlighted
jatneerjat Member
Member

Re: merge queries not working

Hi @MauriceMecowe,

 

Actually the values in one table was in uppercase and in other it was lowercase,once i changed both to lowercase it works.

 

Thanks,

Neeraj