HA5024IB

SQL: SELECT b.PID,b.Bezeichnung,b.Hersteller,b.Datecode,b.Beschreibung,l.Menge,l.VK,l.ID,l.RID FROM bauteile AS b LEFT JOIN lager AS l ON (b.PID = l.PID) WHERE b.Bezeichnung = 'HA5024IB' GROUP BY l.ID ORDER BY VK DESC,Menge DESC; Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db13501163-ede.b.PID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Menge	Bezeichnung	Hersteller	Datecode	Beschreibung	Foto	Datenblatt