MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
Posted by: Roland Bouman
Date: March 02, 2006 06:44PM

Hi Phil

[got a feeling your'e wandering off here - thiis query does not at all resemble the data set samples you posted before - please tell, did that simple query I sent yield the results you expected?]

You still are SELECTing columns that are not in the GROUp BY list. As i explained earlier, you can't do that.



Edited 1 time(s). Last edit at 03/02/2006 06:44PM by Roland Bouman.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
10871
Phil Powell
February 04, 2006 06:30PM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
4649
Roland Bouman
February 06, 2006 06:07PM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2661
Phil Powell
March 01, 2006 10:21AM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2470
Roland Bouman
March 01, 2006 01:32PM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2868
Phil Powell
March 02, 2006 10:41AM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2273
Roland Bouman
March 02, 2006 11:52AM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2149
Phil Powell
March 02, 2006 01:14PM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
3702
Roland Bouman
March 02, 2006 04:40PM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2360
Phil Powell
March 02, 2006 05:24PM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2065
Roland Bouman
March 02, 2006 06:44PM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2112
Phil Powell
March 02, 2006 06:59PM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2091
Roland Bouman
March 02, 2006 07:07PM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2073
Phil Powell
March 02, 2006 07:08PM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2169
Roland Bouman
March 03, 2006 08:27AM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2059
Phil Powell
March 03, 2006 05:20PM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2051
Roland Bouman
March 04, 2006 02:34AM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2186
Phil Powell
March 06, 2006 02:02PM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2443
Roland Bouman
March 06, 2006 02:45PM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2131
Phil Powell
March 06, 2006 05:43PM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2091
Roland Bouman
March 06, 2006 06:22PM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2022
Phil Powell
March 07, 2006 10:39AM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2029
Roland Bouman
March 07, 2006 10:52AM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2202
Inder Singh
February 22, 2008 02:57AM
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2727
Roland Bouman
February 22, 2008 03:49AM


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.