Perhaps I am missing something, but why not do this as an inner join?
SELECT man .name, GROUP_CONCAT( car. make ) AS 'makes'
FROM man
INNER JOIN car ON man. id = car.owner_id
GROUP BY man .id
On my box this query is about 3X faster. I think Mysql is known for not
performing well with (especially
Hi, I have the below setup:
--A man can have multiple cars
CREATE TABLE man (id INTEGER, name VARCHAR(64));
CREATE TABLE car (id INTEGER, owner_id INTEGER, make VARCHAR(64));
--Add data
INSERT INTO man VALUES (1, 'John');
INSERT INTO car VALUES (1, 1, 'Mazda');
INSERT INTO car VALUES (2, 1,