GROUP BY Expression

From: Newsworthy <hannum_at_ohio.edu>
Date: Fri, 23 Apr 1999 12:47:34 GMT
Message-ID: <FAn7CA.7qK@boss.cs.ohiou.edu>

Hello,

I'm using Oracle with Cold Fusion (if anyone here knows what CF is). I have the following query that does not work. Can somebody tell me why?

SELECT *
FROM Students U, Sessions E, Seminars S

WHERE     S.ID = E.ID AND
                    E.SID = U.SID AND
                    E.IID = 235

GROUP BY U.oak_id
ORDER BY U.NameLast, U.NameFirst

It produces the following error in Cold Fusion:

ODBC Error Code = NA000 ()
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00979: not a GROUP BY expression

Thanks in advance to anybody who can help!

---

Dave Hannum
Web Analyst/Programmer
Ohio University
hannum_at_ohio.edu Received on Fri Apr 23 1999 - 07:47:34 CDT