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
Inscription à :
Publier les commentaires (Atom)
Aucun commentaire:
Enregistrer un commentaire