[EMAIL PROTECTED]
> Oggetto: RE: Inventory Query
>
>
> Try this:
>
> SELECT t1.id AS prod_id, t1.description AS
> Description,SUM(t2.quantities) AS Purchases,
> SUM(t3.quantities) AS Sellings, (Purchases-Sellings) AS Inventory
> FROM Products t1 INNER JOIN Purchases t2 ON
> -Original Message-
> From: Gigi Di Leo [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 16, 2002 12:03 PM
> To: '[EMAIL PROTECTED]'
> Subject: Inventory Query
>
>
> Hello list.
>
> Could you please suggest me a one-line query to solve a
&
Hello list.
Could you please suggest me a one-line query to solve a problem of inventory ?
Three table:
Products
-
| id | description |
-
| 01 | bread|
| 02 | milk |
| 03 | coffee |
---
