NAJI GOCHE - regionalny magazyn społeczno-kulturalny

BŁĄD - Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'najigoche.c.nazwa' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT,art.tytul, aut.nazwisko,aut.imie,aut.miejscowosc, c.nazwa,,n.rok,n.numer, CASE WHEN art.cyklID=0 THEN 1000 WHEN art.cyklID>0 THEN 10 ELSE NULL END AS cyklord FROM artykul AS art, autor AS aut, ng AS n, cykl AS c WHERE AND AND (art.cyklID=0 OR GROUP BY ORDER BY art.tytul ASC,n.numer ASC

NAJI GOCHE | e-mail: