dimanche 24 juillet 2016

#1055 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by

the is my Query : select libelle,credit_initial,disponible_v,sum(montant) as montant FROM fiche,annee,type where type.id_type=annee.id_type and annee.id_annee=fiche.id_annee and annee = year(current_timestamp) GROUP BY libelle order by libelle asc Mysql 5.7.9 runs the query without any problem but mysql 5.7.12 display the error above Could you please help me with that

Aucun commentaire:

Enregistrer un commentaire