Re: MySQL 4 to MySQL 5 - SQL syntax question.

[Matthew Good]

I hate to be the guy who responds to his own post - but I think I solved the problem... However I'd like someone to confirm this for me.

I've rewritten the above query to:

SELECT i.cat_id, i.image_name, i.image_media_file, i.image_thumb_file, c.cat_name, u.user_name
FROM IMAGES_TABLE i CROSS JOIN CATEGORIES_TABLE c
LEFT JOIN USERS_TABLE u ON u.user_id = i.user_id
WHERE i.image_id = 5

I believe this is functionally equivalent and will run on MySQL 5, but I'm not as confident in this as I'd like to be, since I'm not very familiar with the original app. I would really appreciate it if someone would confirm (or deny) that this new SQL does the same thing as the old stuff. Thanks again.

-Matthew Good