v.20.1Improvement

First Argument of joinGet Function Can Now Be Table Identifier

Official CH changelog text
Now table the first argument of joinGet function can be table identifier. #7707 (Amos Bird)
The joinGet function now accepts a table identifier as its first argument.

Why it matters

This feature enhances the joinGet function by allowing users to specify the join table directly via its identifier instead of only by table name. This improves flexibility and usability when referencing join tables in queries.

How to use it

Use the joinGet function with the first argument as the table identifier. For example:

SELECT joinGet(table_identifier, 'column', key) FROM ...

where table_identifier refers to the join table.

Related resources

PreviousNext