CREATE TABLE t1(a Int, b Int) Engine = MergeTree ORDER BY a;
CREATE TABLE t2(c Int, d Int) Engine = MergeTree ORDER BY c;
SELECT a as a1, b, a FROM t1 INNER JOIN (SELECT c as a, d FROM t2) ON b = d ORDER BY a;