Answer:
Following are the code to this question:
/*using the select statement, that selects column name from the table blog.posts */
SELECT blog.posts.user_id, blog.posts.body, users.name/*column name user_id, body, name*/
FROM blog.posts/* use table name blog.posts*/
RIGHT OUTER JOIN users ON blog.posts.user_id = users.id;/*use right join that connect table through user_id*/
Explanation:
In the structured query language, RIGHT JOIN is used to recovers from both the right side of the table both numbers, although the left table has no sets. It also ensures that even if the 0 (null) documents are linked inside this left table, its entry will always return the outcome row, but still, the number of columns from its left table will be NULL.
In the above-given right join code, the select statements used that selects the column names "user_id, body, and the name" from the table "blog. posts" and use the right join syntax to connect the table through the id.
