CREATE CURSOR studenti (cod_student int, nume c(15), prenume c(20), facultateid int)
INSERT INTO studenti (cod_student, nume, prenume, facultateid) VALUES (1, 'ION', 'Ion',1)
INSERT INTO studenti (cod_student, nume, prenume, facultateid) VALUES (2, 'DAN', 'Dan',1)
INSERT INTO studenti (cod_student, nume, prenume, facultateid) VALUES (2, 'DAN', 'Dan',2)

CREATE CURSOR cursuri (idcurs int, denumire_curs c(20), profesor c(20))
INSERT INTO cursuri (idcurs, denumire_curs, profesor) VALUES (1, 'Mate','Radu')
INSERT INTO cursuri (idcurs, denumire_curs, profesor) VALUES (2, 'Romana','Vasile')

CREATE CURSOR note (idcurs int, cod_student int, an int, nota int)
INSERT INTO note (idcurs, cod_student, an, nota) VALUES (1, 1, 2001, 8)
INSERT INTO note (idcurs, cod_student, an, nota) VALUES (1, 1, 2002, 9)
INSERT INTO note (idcurs, cod_student, an, nota) VALUES (1, 2, 2001, 9)
INSERT INTO note (idcurs, cod_student, an, nota) VALUES (1, 2, 2002, 10)
INSERT INTO note (idcurs, cod_student, an, nota) VALUES (2, 3, 2001, 7)
INSERT INTO note (idcurs, cod_student, an, nota) VALUES (2, 3, 2002, 8)
INSERT INTO note (idcurs, cod_student, an, nota) VALUES (2, 1, 2001, 7)
INSERT INTO note (idcurs, cod_student, an, nota) VALUES (2, 1, 2002, 8)

PRIVATE pcFacultateID
pcFacultateID=1

SELECT studenti.facultateid, studenti.cod_student, studenti.nume, studenti.prenume, ;
cursuri.denumire_curs, cursuri.profesor, note.an, note.nota ;
FROM studenti LEFT JOIN note ON note.cod_student=studenti.cod_student ;
LEFT JOIN cursuri ON cursuri.idcurs=note.idcurs ;
WHERE studenti.facultateid=?pcFacultateID ;
ORDER BY facultateid, studenti.cod_student, an, denumire_curs