ORACLE : How to create a join with the USING clause in Oracle?

Use the USING clause to specify the columns for the equijoin where several columns have the same names but not same data types.  Use the USING clause to match only one column when more than one column matches.  The NATURAL JOIN and USING clauses are mutually exclusive. Syntax: SELECT n, n FROM table1 JOIN table2 USING (join_column1, join_column2…); Explanation:  table1, table2 are the name of the tables participating in joining.  The natural join syntax contains the NATURAL keyword, the JOIN…USING syntax does not.  An error occurs if the NATURAL and USING keywords occur in the same join clause.  The JOIN…USING clause allows one or more equijoin columns to specify in brackets after the USING keyword. Example: Creating Joins with the USING clause in Oracle In this example, the LOCATIONS table is joined to the COUNTRY table by the country_id column (only column of the same name in both tables). Sample table: locations Sample table: countries SQL> SELECT location_id, postal_code, country_name 2 FROM locations 3 JOIN countries 4 USING (country_id); Copy Sample Output: POSTAL_CODE CITY REGION_ID COUNTRY_NAME ------------ ------------------------------ ---------- ------------------------- 00989 Roma 1 Italy 10934 Venice 1 Italy 1689 Tokyo 3 Japan 6823 Hiroshima 3 Japan 26192 Southlake 2 United