SyntaxFix
Write A Post
Hire A Developer
Questions
SELECT c.id, c.title, p.id AS product_id, p.title FROM categories AS c JOIN products AS p ON c.id = p.category_id GROUP BY c.id
This will return the first data in products (equals limit 1)