MySQL - limit from two connected tables

Question

2 tables:

name  
id | title

and

content  
name | title

One name has several contents. name.id ~ content.name

I need to get 3 names with all theirs content.

SELECT name.title, content.title
FROM name LEFT JOIN content ON name.id = content.name
LIMIT 3

result in 3 contents, not names

Is it possible to do this with one query?

Answer 1

Try this:

SELECT name.title, content.title, content.name
FROM name LEFT JOIN content ON name.id = content.name
LIMIT 0, 3

Also, you need to use an alias because you are selecting two title fields:

SELECT (name.title) as name_title, content.title, content.name
FROM name LEFT JOIN content ON name.id = content.name
LIMIT 0, 3

Update:

I think you need only the name field as far as i could figure out from your comment, try this:

SELECT content.name
FROM name LEFT JOIN content ON name.id = content.name
LIMIT 0, 3

Answer 2

SELECT content.name, content.title
FROM name LEFT JOIN content ON name.id = content.name
LIMIT 0, 3

Answer 3

Subquery?

SELECT name.title, content.title
FROM name LEFT JOIN content ON name.id = content.name
WHERE name.id IN (SELECT name.id FROM name LIMIT 3)