Inspectopedia
 
2024.3

Check using clause columns

Warning
New
Last modified: 03 December 2024

Reports columns in the USING clause that does not exist in both tables.

Example (MySQL):

In USING clauses, a column name must be present in both tables, and the SELECT query will automatically join those tables by using the given column name. As we do not have the j column in t2, we can rewrite the query using ON. The ON clause can join tables where the column names do not match in both tables.

SELECT * FROM t1 JOIN t2 ON t1.j = t2.l;