There are several other types of join syntax offered in Oracle SQL. These join types aren’t used as often, but it’s worth knowing about them and why you should or should not use them.
The USING Keyword
In an earlier chapter you learned how to write a query that used an INNER JOIN to get data from two tables. As part of that you specified how the two tables were related, by indicating the two columns whose values needed to match. Here’s the query you ran:
SELECT
s.id,
s.employee_id,
s.company,
s.meeting_date,
e.last_name
FROM customer_meeting s
INNER JOIN employee e ON s.employee_id ...
