SQL INNER JOIN Query

EasySQL · PostgreSQL

Write a basic SQL query to retrieve data from two tables using an INNER JOIN.

Use the employees and departments tables. Return only employees assigned to a department that exists in the departments table.

Output

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee full name
department_id	INT	Identifier of the employee's department

departments

Column	Type	Description
department_idPK	INT	Unique department identifier
department_name	VARCHAR(100)	Department name

Tablesemployeesdepartments

CodePostgreSQL

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

Run your query to see results here.