Re: Repeating Results in Query

2002-10-31 Thread Michael Stearne
Ahh, thanks. Arthur Fuller wrote: GROUP BY Left(sku,5) hth, Arthur -Original Message- From: Michael Stearne [mailto:mstearne@;entermix.com] Sent: Thursday, October 31, 2002 11:31 AM To: [EMAIL PROTECTED] Subject: Repeating Results in Query The query below: SELECT DISTINCT LEFT(sku,5

RE: Repeating Results in Query

2002-10-31 Thread Arthur Fuller
GROUP BY Left(sku,5) hth, Arthur -Original Message- From: Michael Stearne [mailto:mstearne@;entermix.com] Sent: Thursday, October 31, 2002 11:31 AM To: [EMAIL PROTECTED] Subject: Repeating Results in Query The query below: SELECT DISTINCT LEFT(sku,5) AS Item_Sku,count(*) as Quantity_So