Your question, your audience. Choose who sees your identity—and your question—with question security.
SELECT name, MAX(id) AS id, text,
option
FROM dataset1
LEFT OUTER JOIN dataset2 ON name_fk = name
WHERE something!=1
GROUP BY name
ORDER BY id DESC
LIMIT 15;
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
option
FROM dataset1
LEFT OUTER JOIN dataset2 ON name_fk = name
WHERE something!=1
AND id = (SELECT MAX(ID) from dataset1 x where x.name = dataset1.name)
GROUP BY name
ORDER BY id DESC
LIMIT 15;