DB::Exception: Support for more than one JOIN in query is not implemented.

[John Dolphin]

Try run some query in Clickhouse and get this error, does it mean clickhouse only one join clause? 

Thanks

[Alex Zatelepin]

Hi John!

It means that ClickHouse can only join two tables in one SELECT. You can simulate multi-table join with subqueries like this:

SELECT * from t1 ALL INNER JOIN (SELECT * FROM t2 ALL INNER JOIN t3 USING x) USING x