Re: How to do this query?
From: Roya Mehrfar <roya_mehrfar_at_qmbridge.calstate.edu>
Date: 1996/08/06
Message-ID: <32073274.7A0F_at_qmbridge.calstate.edu>#1/1
Date: 1996/08/06
Message-ID: <32073274.7A0F_at_qmbridge.calstate.edu>#1/1
select item, sum(i.qty), sum(o.qty)
from order o, inventory i
where order.item = inventory.itme
group by item
I am assuming you want to calculate the sum for each item. That is why I am grouping by item. Received on Tue Aug 06 1996 - 00:00:00 CEST