MySQL Forums
Forum List  »  Newbie

Re: Help with SQL Statement
Posted by: Peter Brawley
Date: September 22, 2017 07:41PM

> When adding MEMBERS.MEMBER_ID to the select the query will not run.

Does the error msg mention only_full_group_by? If so, you need to read about that setting, and you can get round the error by adding members.member_id to the Group By clause.

Otherwise, what is the error message, or if there is none then what does "not run" mean?



Edited 1 time(s). Last edit at 09/22/2017 07:43PM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
September 22, 2017 05:58PM
Re: Help with SQL Statement
September 22, 2017 07:41PM
September 23, 2017 09:40AM
September 23, 2017 10: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.