Hello,

   I have two tables

orders:
job_acc_code typefactor codetype orderqty
---------------------------------------------
05A020002 1 S 2124
05A020002 1 M 4248
05A020002 1 L 4248
05A020002 1 XL 2124
05A020001 2 002 125
05A020001 2 005 150
05A020003 3 0 5000

inventory:
job_acc_code typefactor codetype receiveqty
-----------------------------------------------
05A020002 2 S 1500
05A020002 2 M 1000
05A020002 2 S 500

I want to get the report showing all orderdetails and inventory what we have received(totalreceived)

Can anyone give me the query?

I want to get all the details from orderdetails table and details from inventory(sum(receiveqty)) group by job_acc_code,typefactor,codetype

thanks in advance