von WannabeArtist » Di 29 Jul, 2003 10:21
Mit Access kenn' ich mich nicht aus, mit mySQL wĂĽrd' das allerdings z.B. folgendermaĂźen Aussehen:
[php]"SELECT Name, Vorname, dt_titel, Jahr, film.Film_ID as Film_ID FROM personen LEFT JOIN artists AS artists ON(personen.Personen_ID = artists.Personen_ID) LEFT JOIN film_artists AS film_artists ON(artists.Artist_ID = film_artists.artist_ID) LEFT JOIN film AS film ON(film_artists.Film_ID = film.Film_ID) WHERE personen.Personen_ID='".$ids[$i]."' ORDER BY film.dt_titel"[/php]