SQL USING Clause

Last Updated : 15 Sep, 2025

The SQL USING clause is an important feature that simplifies join operations between tables. It allows you to directly specify the column(s) that both tables have in common, removing the need to repeat table aliases for those columns.

  • Simplifies JOIN operations by matching common columns.
  • Ensures cleaner syntax by avoiding column qualification.
  • Works with INNER JOIN, LEFT JOIN, and RIGHT JOIN.

Syntax

SELECT column_list
FROM table1
JOIN table2
USING (common_column);

Example 1: Finding Employee Working Locations

The Employeestable contains information about employees, including their EMPLOYEE_ID, LAST_NAME, and the department they belong to (DEPARTMENT_ID). The Departments table lists department details, including DEPARTMENT_ID and LOCATION_ID.

Employee-table
Employee Table
department-table
Department Table

Query:

SELECT e.EMPLOYEE_ID, e.LAST_NAME, d.LOCATION_ID
FROM Employees e JOIN Departments d
USING(DEPARTMENT_ID);

Output:

USING-Cluase-example-1
USING Clause Example1

Explanation:

This query joins the DEPARTMENT_IDcolumn from the Employees and Departments tables to display the location where each employee works. The USING clause ensures that only the matching DEPARTMENT_IDvalues from both tables are used in the join condition.

Example 2: Retrieving Location and Country Details

The locations table stores address details such as location_id, street_address, and postal_code. The countries table contains country-related information like country_idand country_name.

countries-table
countries Table
locations-table
locations Table

Query:

SELECT l.location_id, l.street_address, l.postal_code, c.country_name
FROM locations l JOIN countries c
USING(country_id);

Output:

USING-Clause-example-2
USING CLause example 2

Explanation:

This query joins the country_idcolumn from the locationsand countriestables to retrieve complete address details along with the respective country names. The USING clause simplifies the join by matching the shared country_idcolumn.

Common Mistakes When Using the SQL USING Clause

1. Qualifying Columns in the USING Clause

Do not qualify the column specified in the USING clause with a table name or alias. Doing so will result in an error.

Incorrect:

SELECT e.EMPLOYEE_ID, e.LAST_NAME, d.LOCATION_ID
FROM Employees e JOIN Departments d
USING (d.DEPARTMENT_ID);

Correct:

SELECT e.EMPLOYEE_ID, e.LAST_NAME, d.LOCATION_ID
FROM Employees e JOIN Departments d
USING (DEPARTMENT_ID);

2. Reusing Columns from the USING Clause in WHERE Conditions

Avoid referencing the USING clause column in WHERE conditions without proper handling, as it may cause errors.

Incorrect:

SELECT l.location_id, l.street_address, l.postal_code, c.country_name
FROM locations l JOIN countries c
USING (country_id)
WHERE c.country_id = 'IT';

Correct:

SELECT l.location_id, l.street_address, l.postal_code, c.country_name
FROM locations l JOIN countries c
USING (country_id)
WHERE country_id = 'IT';

Why Use the USING Clause in SQL?

The USING clause helps avoid ambiguity when joining tables with multiple common columns. It ensures that only specified columns are used for the join condition, resulting in more precise and understandable queries.

  • Reduces redundancy in SQL queries.
  • Improves code readability by eliminating repetitive column references.
  • Ensures accurate JOIN conditions with minimal effort.
Comment

Explore