Re: LIMIT in JOIN

[Felix Geerinckx]

Amir Habibi Wrote:

> If we don't have the 'sort' column, or if the 'sort' column is bad filled (for example
> 1,2,2,2,4) is it possible to acheive this ?

Perhaps you can use the child.id column as a sort column:

SELECT
    parent.id, parent.name,
    c1.id, c1.name
FROM parent
JOIN child c1 ON c1.parent_id = parent.id
LEFT JOIN child c2 ON c2.parent_id = c1.parent_id AND c2.id < c1.id
GROUP BY parent.id, parent.name, c1.id, c1.name
HAVING COUNT(c2.id) < 2
ORDER BY parent.name, c1.name;

--
felix
Please use BBCode to format your messages in this forum.