SQL Group by Question, WHY?

["Hatzenbeler, Tim" <thatzenbeler@xxxxxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
I'm running version 4.5, and I was wondering if all versions of SQL require
this...

if I have a table,

Timstable
------------------
fld1
fld2
fld3

and I want to group this table, but I only need fld2 and fld3, but I want to
group by fld1,  why do I have to put fld1 in the select portion, isn't group
by enough?

Thanks, tim
This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review; use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.