Thread Order by bei JOIN's (14 answers)
Opened by Froschpopo at 2007-05-08 21:44

MartinR
 2007-05-09 09:08
#35446 #35446
User since
2004-06-17
305 Artikel
BenutzerIn
[default_avatar]
vielleicht i.E. so?

Code: (dl )
1
2
3
SELECT users.name, MAX(fotos.id) AS MaxFotoID, fotos.name AS aktuellstes_foto FROM users
 LEFT JOIN fotos ON
    fotos.userid = users.name
\n\n

<!--EDIT|MartinR|1178687991-->

View full thread Order by bei JOIN's