Welcome
Welcome to <strong>Sybase Philippines</strong>.

You are currently viewing our boards as a guest, which gives you limited access to view most discussions and access our other features. By joining our free community, you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content, and access many other special features. Registration is fast, simple, and absolutely free, so please, <a href="/profile.php?mode=register">join our community today</a>!

ASA 9.0 Group by clause not working

ASA 9.0 Group by clause not working

Postby kymel15 on Fri Jun 05, 2009 8:36 am

i am using ASA 9.0 and i have a very simple query like this:

SELECT LASTNAME, FIRSTNAME, MATERNALNAME
FROM EMPLOYEE
GROUP BY LASTNAME

but evrytime i run this query its throwing error:
Function or column reference to FIRSTNAME must also appear in the GROUP BY


as far as i know theres nothing wrong with this query, because i have been using this kind of query in many databases, as well as ASE.
Can anyone help me how can i resolved it?

Thanks in advance...
kymel15
 
Posts: 4
Joined: Tue Jul 29, 2008 6:36 am

Return to General Information

Who is online

Users browsing this forum: No registered users and 0 guests

cron