v.21.11Improvements

Allow Mixing JOIN with USING and Other JOIN Types

Official CH changelog text
Allow to mix JOIN with USING with other JOIN types. #23881 (darkkeks).
Allow mixing JOIN with USING clause with other JOIN types in queries.

Why it matters

This feature enables users to combine JOIN statements using the USING clause alongside other JOIN types within a single query. It resolves previous limitations where such combinations were disallowed, enhancing query flexibility and expressiveness.

How to use it

Users can now write queries that mix JOIN statements with the USING clause and other join types in any order or combination without restrictions. For example:

SELECT *
FROM table1
JOIN table2 USING (common_column)
LEFT JOIN table3 ON table1.id = table3.id


This feature requires no special configuration and is available by default after upgrading to the version including this change.

Related resources

PreviousNext