Connector does not handle SUM(table_name.Column)
Posted by: jacek.blaszczynski
Date: October 29, 2004 08:00AM


The following SQL query works perfect with any DB I use in my development work (MSDE, Oracle 9i, MySQL 4.1.7) with all connectors except MySQL Connector

SELECT u.UserID, User, Password, email, RegisteredSince, LastModified, UNameModified, sum(r.RoleID) FROM Users u, UsersRoles r WHERE User=@user AND r.UserID = u.UserID GROUP BY u.UserID;

ATTENTION: I have replaced @ with ? there for MySQL Connector - its nonsense syntax anyway.

Is it a bug?



Options: ReplyQuote

Written By
Connector does not handle SUM(table_name.Column)
October 29, 2004 08:00AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.