Join über mehrere Tabellen

select Student1.matnr, Student1.nname, BiLeihe.ISBN, BiBooks.titel
from   Student1 
JOIN BiLeihe ON (BiLeihe.matnr = Student1.matnr)
JOIN BiBooks ON (BiLeihe.ISBN = BiBooks.ISBN);