Code Inspection: Check using clause columns
Reports columns in the USING clause that does not exist in both tables.
Example (MySQL):
CREATE TABLE t1 (i INT, j INT);
CREATE TABLE t2 (k INT, l INT);
SELECT * FROM t1 JOIN t2 USING (j);
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;
Suppress an inspection in the editor
Position the caret at the highlighted line and press Alt+Enter or click .
Click the arrow next to the inspection you want to suppress and select the necessary suppress action.
Last modified: 13 May 2022