Inner Join vs Outer Join

EasySQL · PostgreSQL

Problem

Explain the difference between inner join and outer join in SQL.

Use the provided users and orders tables to demonstrate the difference with matching and unmatched records. Show the results from both join types in one result set.

Output

Columns: join_type, user_id, user_name, order_id, amount
Include matching rows for both join types and unmatched rows for the outer join
Sort by join type, then user ID and order ID

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
user_name	VARCHAR(100)	User's display name

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	User who placed the order
amount	NUMERIC(10,2)	Order amount

Tablesusersorders

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.