The conversation between human and AI assistant.
[|Human|] Create a SQL query that joins two tables.
[|AI|] SELECT users.name, blogposts.title
FROM users
JOIN blogposts
ON users.id = blogposts.author_id;

This query will join the two tables (users and blogposts) on the common column of `id` from the `users` table and `author_id` from the `blogposts` table. The result will be a table showing the `name` of the author from the `users` table and the `title` of the blog post from the `blogposts` table.
[|Human|] 
Create a SQL query that joins two tables.