Search⌘ K
Home/
Courses/
SQL Interview Preparation

Answer: Using LEFT JOIN

Find a detailed explanation of how to apply LEFT JOIN on tables.

We'll cover the following...

Solution

The solution is given below:

MySQL
/* The query to apply LEFT JOIN */
SELECT    e.EmpName, p.ProjectName
FROM      Employees AS e 
LEFT JOIN Projects AS p ON e.EmpID = p.EmpID;

Explanation

The explanation of the solution code is given below:

  • Line 2: The SELECT query selects EmpName and ProjectName from Employees and Projects, respectively. We use AS to set an alias for the tables.

  • Line 3: The data is retrieved from the Employees table.

  • Line 4: LEFT JOIN is applied with Projects on columns EmpID in both ...