Re: convert query from mysql

On 18/12/13 10:55, Mike Andrewjeski wrote:
> [...]
> > Here's the mysql query:
>
> > select nodes.name, GROUP_CONCAT(node_groups.name) from node_groups,
> > node_group_memberships, nodes where nodes.id =
> > node_group_memberships.node_id and node_groups.id =
> > node_group_memberships.node_group_id and nodes.name IN (SELECT name
> > from nodes) group by nodes.name order by nodes.name")
[...]

Just noticed the IN clause...

The semantics of how NULLS are handled is different, but you might find
it more efficient if you don't use IN, but something like:

(SELECT n2.name FROM nodes n2 WHERE n1.name = n2.name)

I always uses aliases for tables, especially when I'm dealing with more
than one table in an SQL statement.


Cheers,
Gavin