Hello together,
I hope someone can help. Im playing around with a query resulting from ODLN the delivery table. I like to inner join to dln1 and do a count of the positions and a count of the items per position regarding to DocNum in ODLN.
Like that:
DocNum / [Position Total] / [Items Total]
[123456] / [6] / [60]
Thanks in advanced for your help.
Cheers
Andreas