I think i need to do something about my db-knowledge ...
Thanks,
Johan
-----Original Message-----
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: maandag 31 juli 2000 12:52
To: '[EMAIL PROTECTED]'
Subject: RE: Desperately need help - sorting a QueryNew()
> When you sort on mathematical expressions like SUM() you need to use GROUP
> BY. ORDER BY cannot contain mathematical expressions.
That's a bit misleading.
1. In most RDBMS, including Access which is what we're talking about, if you
can SELECT BY it, you can ORDER BY it.
2. SUM() is an aggregate function, rather than just a mathematical
expression.
3. GROUP BY and ORDER BY serve completely different purposes.
Nick
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
----------------------------------------------------------------------------
--
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.
------------------------------------------------------------------------------
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.
