Re: SQL query

Select date, packing_list, item_code, sum(qty), lot from table1
group by date, packing_list, item_code, lot

(you have to group by all the items other than the summed item)

Marsha Campbell
marsha_campbell_at_c4corp.com

"Elena" <quan.e_at_neologistica.it> wrote in message news:b4hpe0$mfc$1_at_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 Tue Mar 11 2003 - 13:11:18 CST