Search⌘ K
AI Features
Home
Courses
SQL Interview Preparation

Answer: Using LEFT JOIN

Explore how to use the LEFT JOIN operation in SQL to combine data from multiple tables, specifically retrieving employee and project information. Understand the use of aliases, selective column retrieval, and alternative join techniques like USING and RIGHT JOIN. This lesson helps you confidently write and interpret LEFT JOIN queries for effective data management.

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  ...