> Try ORDER BY SUM(PurchaseItem.Quantity)
> > I guessed that was because AmountSold doesn't actually
> exist (ie it's the
> > result of the aggregate function). So I tried ORDER BY
> > SUM(PurchaseItem.Quantity) but that doesn't work either
> (hence resorting
> to
> > sorting the query after the event).
Thanks for the suggestion but been there, tried it, bought the error message
:-)
--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
