Forum Discussion

jatneerjat's avatar
jatneerjat
Icon for Helper V rankHelper V
8 years ago
Solved

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 returnin...
Need Help
  • jatneerjat's avatar
    jatneerjat
    8 years ago

    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

     

MauriceMecowe's avatar
MauriceMecowe
Icon for Resolver II rankResolver II
8 years ago

Hi jatneerjat

 

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

jatneerjat's avatar
jatneerjat
Icon for Helper V rankHelper V
8 years ago

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