Reply
Member
Posts: 121
Registered: ‎05-29-2018
Accepted Solution

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


Accepted Solutions
Highlighted
Member
Posts: 121
Registered: ‎05-29-2018

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

 

View solution in original post


All Replies
Regular Visitor
Posts: 22
Registered: ‎07-03-2018

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
Member
Posts: 121
Registered: ‎05-29-2018

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