I have two queries(qry_order, qry_receive).
jobCode typefactor codetype totQtyOrdered
jobCode typefactor codetype totQtyReceived
I want a query to select jobCode,typefactor,codetype,totQtyOrdered,totQtyRe ceived,totQtyOrdered-totQtyReceived as balance from these two queries.
I tried, left join, union, join but no result. Wat my aim is when i am receiving the material, i want to show the user Total quantity ordered for that job till now and total we received and balance to be received. If no qty is received only data from ordered table is shown.
Wat could be the query. Every response is highly appreciated.