Urgent: Help with grouping SQL!!

From: Billy Collins <queerczar_at_unforgettable.com>
Date: Wed, 07 Feb 2001 06:47:50 GMT
Message-ID: <95qr2m$oh3$1@nnrp1.deja.com>

I have a SALE table which stores the information about each PRODUCT that is sold by the company. Of course, now there is is a date of the sale as well. Now, I need to report this information in the following manner:

                Sales during the week beginning Feb 5

                    Mon   Tue   Wed   Thu   Fri
                    05/02 06/02 07/02 08/02 09/02

     PRODUCT 1        23     34    67    22    89
     PRODUCT 2         5     10    20     6    25
     ...

What SQL can I write? My tables look like this:

            PRODUCT
               Product Id, Product name

            SALE
               Product Id, Date of Sale, Quantity of Sale

I would appreciate any help!

Thanks,
Billy

Sent via Deja.com
http://www.deja.com/ Received on Wed Feb 07 2001 - 00:47:50 CST