Forum Discussion

amitkala17's avatar
amitkala17
Regular Visitor
9 years ago
Solved

left join in Report

Hello,   i have two query in my report and i am trying to implement left join, here is the scenario, i have a main table called Emp, and one other table Organaziation, i want to see all the record...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi amitkala17,

    Based on my test, NATURALLEFTOUTERJOIN doesn’t work in this scenario.

    In Query Editor, click on the Emp table, then select “Merge Queries as New” to merge the two tables, then expand the orgname column in the merged table. It doesn’t impact on your current tables using the merge query feature to get expected result.


    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi amitkala17,

Based on my test, NATURALLEFTOUTERJOIN doesn’t work in this scenario.

In Query Editor, click on the Emp table, then select “Merge Queries as New” to merge the two tables, then expand the orgname column in the merged table. It doesn’t impact on your current tables using the merge query feature to get expected result.


Thanks,
Lydia Zhang

Iypnp39's avatar
Iypnp39
Frequent Visitor
3 years ago

hii 
amitkala17 
I Create a report This type of merge (left join),Report Locally working good but i published on Workspace(web cloud) ,Sheduled Refresh(Update) is not working.You have any idea pls give it.