Was looking for my note about the new mysql 5 join syntax just now, but couldn't find it because I was searching for "syntax", which wasn't in the post. =P I can never remember if the manual's suggested replacement syntax for the comma is JOIN or INNER JOIN