Joins take some time to get used to, but the key to understanding them and using them effectively is practice!
To incorporate data from more than two tables, you can utilize multiple joins to execute more complex queries!
SELECT *
FROM employees
LEFT JOIN departments
ON employees.department_id = departments.id
INNER JOIN regions
ON departments.region_id = regions.id;
Our front-end team is finalizing the profile page for CashPal. We need to write a query that returns all the user data they need for an individual user's profile. The query needs to return the following fields:
Return only a single user record - specifically the one with id=6.