clickhouse left join查询on后面不生效

最近在学习clickhouse 用了两张表进行关联生成一张新表

语法

insert into table(a,b,c)
    select a,b,c from Atable a
    left join Btable b on  a.id = b.id and a.xxx = '20220801' 

但是这个代码后面 a.xxx = '20220801'  一直不生效

后面才知道  要改成

insert into table(a,b,c)
    select a,b,c from Atable a
    left join Btable b on  a.id = b.id where a.xxx = '20220801'