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

  • amitkala17's avatar
    amitkala17
    Regular Visitor
    9 years ago

    Thanks Dear,

     

    i got this one, 

    what i understood is by default all queries are linked with inner join, and if we have a requirement of left/right join we need to create a seprate query.

    correct me if i am wrong.

     

  • 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.