--! qt:dataset:src
DROP TABLE IF EXISTS tlbtest;
create table tlbtest (key int, key1 int, key2 int);
select key, key1, key2 from (select a.key, 0 as key1 , 0 as key2 from tlbtest a inner join src b on a.key = b.key) a group by key, key1, key2;
select key, key1, key2 from (select a.key, 0 as key1 , 1 as key2 from tlbtest a inner join src b on a.key = b.key) a group by key, key1, key2;