RIGHT JOIN (or RIGHT OUTER JOIN): It’s the opposite of a LEFT JOIN. It keeps all rows from the right table and matches from the left. Less common than LEFT JOIN, but good to know it exists.
The project uses an e-commerce database with the following tables: ...
3. Select all data from the offices table Now that we know what tables are available, let's write our first SQL query! We will use SELECT * to retrieve all columns from this table, and FROM offices to ...