CS TECHIIE
Menu

SQL Program 24: Inner join employee departments

Praveen KulkarniPraveen Kulkarni

SQL learning illustration

CS TECHIIE | SQL Notes and Solutions

Practical SQL exercise: Returns matching employee and department rows.

Objective

Returns matching employee and department rows.

Explanation

Read the statement clause by clause and predict the result before executing it. These examples use common relational SQL; table setup and exact syntax can vary between MySQL, PostgreSQL, SQL Server, Oracle and SQLite.

Safety check

Before running UPDATE or DELETE, run a SELECT with the same WHERE condition. Use a test database and a transaction for changes you need to verify.

Program / SQL Solution

SELECT e.employee_name,d.department_name FROM employees e INNER JOIN departments d ON e.department_id=d.department_id;

Practice and revision

  • Run the example and verify the output.
  • Change the input and test normal, boundary and invalid cases.
  • Write the solution again without looking at the notes.

Learn • Practise • Build • Secure — CS TECHIIE