LEFTOUTER JOIN

(0) Share

Report

Posted on by P NOUSHAD

1,771

How we can create left outer join between tables in Reports by using dexterity or report writer tools. I have one primary table which contain all sales line items including item without serial numbers and Secondary table which store serial numbers of sales line items of primary table. if the sales line item is not serial item enabled, then there is no corresponding records will be stored in secondary table. But when create relationship between these 2 table, it brings data only if there is serial number of sales line item in secondary table. or it create INNER JOIN between table, But I need LEFTOUTER JOIN so it print all the line items including sales line items without serial numbers.

Kindly provide solution with details