I have 2 tables customer and orders and i want id,customer,item,qty to be displayed in a separate table how to do it. And for single Id and customer i need the items to be comma separated and with overall qty.
for eg. for ID D00001 customer is ABC and items must display as 1234,5678 and qty must be 975. Can anyone help me out