Learning SQL - Join

If the names of the columns used to join the two tables are identical, which is true in the previous query, you can use the using subclause instead of the on subclause

SELECT c.first_name, c.last_name, a.address 
FROM customer c INNER JOIN address a 
USING (address_id);

With using, the identity column will not appear twice.

Using straight_join to join in particular order. For example:

SELECT STRAIGHT_JOIN c.first_name, c.last_name, ct.city 
FROM city ct INNER JOIN address a 
ON a.city_id = ct.city_id 
INNER JOIN customer c 
ON c.address_id = a.address_id

This example use city table as the driving table and to then join the address and customer tables follow up with city table(the order will remain the same as in city table).