Re: SQL Query
From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Thu, 24 Apr 2003 03:21:44 GMT
Message-ID: <cLIpa.593001$L1.170296_at_sccrnsc02>
Date: Thu, 24 Apr 2003 03:21:44 GMT
Message-ID: <cLIpa.593001$L1.170296_at_sccrnsc02>
First problem - no join clause, so you are doing a cartesian product - try adding one as follows (untested)
> select ord.item, sum(ord.qty), sum(invt.qty)
> ,(sum(ord.qty)-sum(invt.qty))
> from ord, invt
where invt.item = ord.item
> group by ord.item
>
Received on Thu Apr 24 2003 - 05:21:44 CEST