Help on Query

Greetings,

Could somebody help on the following.

Thanks,
Ashoke  

I have a table with the following values

Lot#  lot_desc 	start_date qty
1  	Sample	09/02/2005 1
1     Sample      09/03/2005 2
2  	Sample	09/02/2005 1
2     Sample      09/03/2005 2
3  	Sample	09/02/2005 1
3     Sample      09/03/2005 2
4  	Sample	09/02/2005 1
4     Sample      09/03/2005 2
4  	Sample	09/04/2005 1
4     Sample      09/05/2005 2

The output must be like the following:

Lot#1 Lot_desc sum(qty) 09/02/2005 09/03/2005 09/04/2005 09/05/2005

1	Sample	3		1		2
2	Sample	3		1		2
3	Sample	3		1		2
4	Sample	6		1		2		1

Is this possible with one single statement? If so, could you please send me the query.

--
http://www.freelists.org/webpage/oracle-l