Table 1: users
| id | name  |
| -- | ----- |
| 1  | John  |
| 2  | Sarah |

Table 2: blogposts
| id | author_id  | title |
| -- | ---------- | ----- |
| 1  | 1          | Post1 |
| 2  | 2          | Post2 |
创建一个 SQL 查询，连接两张表。
SELECT users.name, blogposts.title 
FROM users 
INNER JOIN blogposts 
ON users.id = blogposts.author_id;