1SELECT
2  u.name,
3  p.title
4FROM
5  users AS u
6  INNER JOIN posts AS p ON u.id = p.user_id