v.19.3Improvements

SELECT * FROM a JOIN B USING A, B Now Return a and B Columns Only from the Left Table

SELECT * FROM a JOIN b USING a, b now return a and b columns only from the left table. #4141 (Artem Zuikov)
The JOIN USING syntax in ClickHouse now returns the columns listed in the USING clause only from the left table.

Why it matters

This change addresses the ambiguity in JOIN USING by ensuring that columns specified in the USING clause are included exclusively from the left table in the result set. This provides more predictable and consistent query results to users.

How to use it

When performing a join with the USING clause, such as SELECT * FROM a JOIN b USING (a, b), the resulting columns a and b will be selected from the left table a. No additional user action is needed to enable this behavior; it is applied by default in queries using JOIN USING.