Search⌘ K
AI Features
Home
Courses
SQL Interview Preparation

Answer: Using RIGHT JOIN

Explore how to use the SQL RIGHT JOIN operation to retrieve data from two tables by including all records from the right table and matching ones from the left. Learn about table aliases, selective columns, and alternative methods like USING, LEFT JOIN, and subqueries to achieve similar results, enhancing your SQL query skills for interviews.

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.

  • Line 4: RIGHT JOIN is applied with Projects on columns EmpID in both the tables. ...