Select query with multiple joins won't work

[ericchuawc]

I need some help.

I have managed to migrate some of MySQL 5.1 tables to Clickhouse.

Basic select query works fine with 1 inner join.

However I noticed if I have more than 1 join e.g.

select
from table1
inner join table2
on table1.a = table2.a
inner join table3
... (more joins left join or inner joins)

This won't work in ClickHouse (it works in MySQL)

Do you have any recommendations how to rewrite this query inside ClickHouse? Otherwise what is the best approach to do this?

Thanks.

[sv3t0sl4v]

Yes. With sub-queries with good WHERE and/or HAVING statements most probably.