Configurable Join support for report creation 

Zoho Reports now allows you to choose between Left or Right type join while creating reports (Charts, Pivot Table and Summary View) over related (linked) tables. This option will provide much more flexibility in creating reports. You can find this option in the Table Relationship dialog.

• Left Join - Report will be computed with  all  the rows from the child table (left) and only the  matching  rows from the parent table (right). Matching is done based on lookup columns defined between child & parent tables. This will be the default join type.
• Right Joint - Report will be computed with  all  the rows from the parent table (right) and only the  matching  rows from the child table (left). Matching is done based on lookup columns defined between parent & child tables. 

Let's say you have joined  Employees  (parent table) and  Tasks Completed  (child) tables through a Lookup column  Employee Name . If you want to create a report to show the tasks completed by each employee.

Left join will return all employees who have  1 or more completed tasks  in their name.

Where as Right join will return all employees, including those with  no completed tasks  at all.