Sometimes you can replace joins on ClickHouse using where clauses, having the same performance as with Join engines. Learn how here....