hi i have a problem with a select distinct command, it just wont eat
it.

this is the code, the databases all exist so that shouldnt be the
problem
<?
$query = "SELECT DISTINCT users.userid, adressen.nachname,
adressen.vorname, adressen.personenid AS adressen_personenid

FROM adressen
INNER JOIN users ON adressen.personenid = users.personenid
INNER JOIN klassen
INNER JOIN module
INNER JOIN kurse
INNER JOIN dozentenliste
INNER JOIN ereigniss ON dozentenliste.ereignissid =
ereigniss.ereignissid
ON klassen.klassenid = ereigniss.klassenid
INNER JOIN klassenzuteilung
ON klassen.klassenid = klassenzuteilung.klassenid
ON users.userid=klassenzuteilung.userid

WHERE klassenzuteilung.userid = '".$_SESSION[UserData][UserID]."'
";

echo getHTMLselectlist($query, "Form[DozentID]");
?>


this is the error message i get

Query: SELECT DISTINCT users.userid, adressen.nachname,
adressen.vorname, adressen.personenid AS adressen_personenid FROM
adressen INNER JOIN users ON adressen.personenid=users.personenid
INNER JOIN klassen INNER JOIN module INNER JOIN kurse INNER JOIN
dozentenliste INNER JOIN ereigniss ON
dozentenliste.ereignissid=ereigniss.ereignissid INNER JOIN ereigniss
ON klassen.klassenid=ereigniss.klassenid INNER JOIN klassenzuteilung
ON klassen.klassenid=klassenzuteilung.klassenid INNER JOIN
klassenzuteilung ON users.userid=klassenzuteilung.userid WHERE
klassenzuteilung.userid = '7'

Error: Fehler beim Senden der Abfrage: You have an error in your SQL
syntax near 'INNER JOIN module INNER JOIN kurse INNER JOIN
dozentenliste IN' at line 6


thanks in advance

ON clauses associate with the nearest JOIN operator. Try using the
old notation:

SELECT DISTINCT users.userid, adressen.nachname,
adressen.vorname, adressen.personenid AS adressen_personenid
FROM adressen, users, klassen, module, kurse, dozentenliste,
ereigniss, klassenzuteilung
WHERE adressen.personenid = users.personenid
AND dozentenliste.ereignissid = ereigniss.ereignissid
AND klassen.klassenid = ereigniss.klassenid
AND klassen.klassenid = klassenzuteilung.klassenid
AND users.userid = klassenzuteilung.userid
AND klassenzuteilung.userid = '.$_SESSION[UserData][UserID].';

And we see that you have 8 tables and only 5 join predicates!