Hello there,
is there any options to turn this code with minus to left join code? Because my database doesnt allow MINUS operator.
Here is my code so far
SELECT studenti.jmeno, studenti.prijmeni (( SELECT studenti.jmeno, studenti.prijmeni FROM studenti WHERE rocnik=1 ) MINUS (SELECT studenti.jmeno, studenti.prijmeni FROM studenti JOIN studenti_predmety USING (id_student) JOIN predmety USING (id_predmet) WHERE studenti_predmety.datum="2020-04-07" AND studenti.rocnik=1 AND predmety.zkratka="MAT1"))