MySQL Forums
Forum List  »  MySQL Query Browser

Re: 1111 error: invalid use of group function
Posted by: Miguel Ángel Pérez
Date: October 27, 2010 01:01PM

This error has been solved by adding

GROUP BY CONCAT(tbldirectores.nombre,tbldirectores.apellidos)

at the end of the select statement.

The function works in MySQL QUERY BROWSER but when NyA has more than a row, the result fails giving the error 1172:

Result consisted of more than one row



Thanks for any help given.

Options: ReplyQuote


Subject
Written By
Posted
Re: 1111 error: invalid use of group function
October 27, 2010 01:01PM


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.