SQL> SELECT location_id, street_address, postal_code, country_name 2 FROM locations 3 JOIN countries 4 USING (country_id);
SELECT table1.column, table2.column FROM table1 JOIN table2 USING (join_column1, join_column2…);