20.11.1.5065.

CREATE TABLE test_join (serial String, appid UInt16) ENGINE = Join(ANY, INNER, serial);
INSERT INTO test_join (serial,appid) values ('aaa',123),('bbb',345);
CREATE TABLE test(serial String, val UInt32) ENGINE = TinyLog;
INSERT INTO test (serial,val) VALUES ('aaa',1111),('bbb',22222);


SELECT *
FROM test
ANY INNER JOIN test_join USING (serial)

Query id: 02c7efc9-0580-4292-ae1a-1bc98289c283

┌─serial─┬───val─┬─appid─┐
│ aaa    │  1111 │   123 │
│ bbb    │ 22222 │   345 │
└────────┴───────┴───────┘

2 rows in set. Elapsed: 0.001 sec.

:) select * from test any inner join test_join USING serial

SELECT *
FROM test
ANY INNER JOIN test_join USING (serial)

Query id: a3cd3230-9fd1-44d7-bf0b-da4b94e07081

Ok.

0 rows in set. Elapsed: 0.001 sec.