Re: How to do this query?

David Cui wrote:
>
> Dear Netters:
>
> Assume I have two tables like these
>
> inventory
> item(char), qty(number)
>
> order
> order_number( char ), item(char), qty(number)
>
> I want to have report like this
>
> item, sum( qty from inventory ), sum ( qty from order )
>
> How can I do this?
>
> Thanks
>
> David

Try this

select iv.item,sum(iv.qty),sum(od.qty)
from order od, inventory iv
where iv.item = od.item
group by iv.item;

Dave Roth Received on Tue Aug 06 1996 - 00:00:00 CEST