Search⌘ K
AI Features
Home
Courses
SQL Interview Preparation

Answer: Using RIGHT JOIN

Explore how to use the RIGHT JOIN in SQL to combine data from two tables based on a related column. Understand selecting specific columns, applying table aliases, and alternative approaches like USING, LEFT JOIN, and subqueries for retrieving joined data efficiently.

We'll cover the following...

Solution

The solution is given below:

MySQL
/* The query to apply RIGHT JOIN */
SELECT     e.EmpName, p.ProjectName
FROM       Employees AS e 
RIGHT 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.

  • Line 3: The data is retrieved from the Employees table. We use AS to set an alias for the tables. ...