Uspesne spojeno DB vybranaMySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY s.id_studenta' at line 5 Behem provadeni SQL dotazu:
SELECT s.id_studenta, p.id_pedagoga, CONCAT( s.jmeno, " ", s.prijmeni ) AS jmeno_studenta, CONCAT( p.jmeno, " ", p.prijmeni ) AS jmeno_pedagoga
FROM `studenti` AS s
JOIN pedagogove_maji_studenty AS pms ON pms.id_studenta = s.id_studenta
JOIN pedagogove AS p ON p.id_pedagoga = pms.id_pedagoga;
ORDER BY s.id_studenta;