11. 1. Challenge

A simple blog database

A sql-5-7.sql file has been opened for you.

In the sql-5-7.sql file:

Use the blog database

Write a SQL RIGHT OUTER JOIN statement that joins the user_id column from the blog.posts table, the namecolumn of the blog.users table and the body column of the blog.posts table together.

11. 1. Challenge A simple blog database A sql-5-7.sql file has been opened for you. In the sql-5-7.sql file: Use the blog database Write a SQL RIGHT OUTER JOIN statement that joins the user_id column from the blog.posts table, the name column of the blog.users table and the body column of the blog.posts table together.

This is my code

USE blog; SELECT posts.user_id, posts.name, posts.body FROM posts p RIGHT OUTER p.user_id ON p.posts.users = p.body;

but it didn't work it give me an error can someone please help me to figure out why and whats wrong

LAST RUN on 8/2/2018, 4:48:18 PM

[Error]: Task 2. Your SQL query is not correct. Try again.