Hey how do I combine two clickhouse queries
# support
h
Hey how do I combine two clickhouse queries
s
You can write a single ClickHouse query that combines the result of two queries by using subqueries.
h
Can you give me an example
v
You can use
WITH
to write subqueries, here’s example: https://onelinerhub.com/clickhouse/using-subqueries-in-with-queries
Also I am curious to know why you had to write clickhouse query? For most of queries, query builder works. Have you tried query builder?
h
It says I've exhausted the amount of panels that can be created using query builder
v
You can upgrade to paid plan which will offer unlimited panels, alerts and more advanced features.
h
where can I check what features are available for free plan?