Repeating Results in Query

[Michael Stearne]

The query below:

SELECT DISTINCT LEFT(sku,5) AS Item_Sku,count(*) as Quantity_Sold, SUM(price) AS Total_Sales FROM `orderline` WHERE (order_date>='20021030' AND order_date<='20021031') GROUP BY sku ORDER BY Item_Sku ASC

Produces results like:

Item_Sku Quantity_Sold Total_Sales
LE104 1 18
MD008 1 25
MD012 1 5
MD103 1 18
MD104 10 400
MD104 3 120
MD201 1 18
MS012 2 6
MS022 1 5
MS106 1 18
MS107 1 18

The Sku field has values like:
MD104-bk-HZ456-LG
MD104-bk-HZ456-MD
MD104-bk-HZ456-XL

But I would like to group and find distinct matchings by just the first 5 characters of sku. But in the example MD104 repeats. Any idea why this is the case?

Thanks,
Michael




---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php