Search Results

Those are the lines I was originally thinking along... but,

That will simply display the distinct city values, and only not show ones where "bob" is the only name associated.

I have now...

Solved:

SELECT DISTINCT(x.city) FROM places x WHERE NOT EXISTS (SELECT 1 FROM places y WHERE y.name = 'bob' AND x.city = y.city);

Hi all,

I have an interesting and I am sure simple question for yau'll.

Basically this is what I am after:

The table:
CREATE TABLE places (id INT, city VARCHAR(24), name VARCHAR(24));
...