Consider a scenario where you want to retrieve a list of employees and their assigned projects. However, some employees are not assigned to any project. Which type of JOIN would be best suited to get this information without omitting any employee?
- LEFT JOIN
- INNER JOIN
- RIGHT JOIN
- FULL OUTER JOIN
A LEFT JOIN retrieves all rows from the left table (employees) and the matching rows from the right table (projects). It includes employees with no matching projects, meeting the requirement.
Loading...
Related Quiz
- You need to destroy a session in your PHP script. How would you do this?
- You have a PHP script and you need to access a constant of a class. How would you do this?
- An instance of an abstract class can be created in PHP.
- What does PEAR stand for?
- If the file to be included using the include statement in PHP is not found, the script will ______.