Hi there,
I have extension field of myWorkorder Id in Inventtransfertable which is same as workorder id from workOrderTable
& salesline.InventRefID which is same as work order id from workOrderTable
Here the requirement is i need to fetch workorder detaisl if workorder id from work order table exists in either sales line or inventtarnsferline,for that i have written a query which i have attached below but i'm getting records from inventtransferline if the workorderid matches with workordertable but i'm getting salesline records if workorderid matches with workordertable.
In the above i used inner join for inventtransferline and outerjoin for salesline and I'm getting only matching records from inventtransferline. If i use inner join for both datasources I'm getting any values form either inventtransferline or sales line.
