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

[Lord ExoskeletoN]

You make me smile Matt..when you say "I hate to be the guy who responds to his own post"...just like what happens to me...but hows ur problem goin..did it work already?

Matthew Good Wrote:
-------------------------------------------------------
> 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