MySQL Forums
Forum List  »  Newbie

Re: Convert Query from using Subqueries, compatible with MySQL 3.23
Posted by: Claude Martin
Date: April 05, 2005 01:11AM

> Anyone have any ideas?

hm, for me it looks like this woule be the same:

SELECT g.id, g.name, g.description, p.permission
FROM groups g LEFT JOIN permissions p ON(id=3 AND (g.id=p.group_id OR p.group_id IS NULL))

> (wrote that off the top of my head .. don't
> remember if MySQL uses "select ... from table t"
> or "select ... from table as t" ..but should get
> the point across I think)

it's both possible

http://animalliberation.tk http://veganismus.ch
http://maqi.de http://tierrechtskochbuch.de

Options: ReplyQuote


Subject
Written By
Posted
Re: Convert Query from using Subqueries, compatible with MySQL 3.23
April 05, 2005 01:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.