1SELECT u.name, p.title FROM users u INNER JOIN posts p ON u.id = p.user_id