<CFQUERY NAME = "Studentensuche" USERNAME = "erika" PASSWORD = "mustermann" DATASOURCE = "dbs" DBTYPE = "ODBC" > SELECT distinct s.matrnr, s.name FROM professoren p, vorlesungen v, hoeren h, studenten s WHERE s.matrnr = h.matrnr AND h.vorlnr = v.vorlnr AND v.gelesenvon = p.persnr AND p.name = '#FORM.Profname#' </CFQUERY> <HTML> <HEAD> <TITLE> Studenten eines Professors </TITLE> </HEAD> <BODY> <CFOUTPUT> Professor #FORM.Profname# hat folgende Hörer: <P> </CFOUTPUT> <CFOUTPUT QUERY="Studentensuche"> #matrnr# #name#<BR> </CFOUTPUT> </BODY> </HTML>