I have a requirement to display all invoice lines and its related shiplines(the key is the shipped 0 line, which has not converted into invoice) by invoice#
I can get the data using the sql below:
select* from ARTran a
full join SOShipLine c on a.SOShipmentLineNbr=c.LineNbr and a.SOShipmentNbr=c.ShipmentNbr
left join SOOrderShipment b on c.ShipmentNbr=b.ShipmentNbr
The key here is the “or” where condition.
However , when it comes to report designer
I can only either group by artran.ref / arinvoice.ref
group by soordershipment.invoicenbr
either way, I would get data lost.
Best answer by lauraj46View original