SQL query

From: Elena <quan.e_at_neologistica.it>
Date: Mon, 10 Mar 2003 11:29:25 +0100
Message-ID: <b4hpe0$mfc$1@lacerta.tiscalinet.it>

Hi,
I have a table1 like this:

DATE            PACKING LIST    ITEM CODE    QTY    LOT        DESCRIPTI
24-FEB-03    211011290OP        21140320011    7        23408            ...
24-FEB-03    211011290OP        21140320011    2        23410            ...
24-FEB-03    211011290OP        26340791011    5        23408            ...
24-FEB-03    211011290OP        26340791011    2        23408            ...
27-FEB-03    21108433               26247383011    6        29510


...

27-FEB-03    57840320058         20143344011    3        29510


...

27-FEB-03    57840320058         20143344011    10      29510

I would like to have the following OUTPUT from a query which I'm not able to write.

DATE                PACKING LIST    ITEM CODE        QTY        LOT
24-FEB-03        211011290OP        21140320011          7          23408
24-FEB-03        211011290OP        21140320011          2          23410
24-FEB-03        211011290OP        26340791011          7          23408
27-FEB-03        21108433               26247383011          6
29510
27-FEB-03        57840320058         20143344011          13        29510

In a few words: I should obtain for the same date, packing-list, item code and lot the amount of quantity.

Can anyone help me?

Thanks in advance.

Elena Received on Mon Mar 10 2003 - 04:29:25 CST