mysql不同查询条件用一条查询语句完成

Question

现在有两条查询语句
select date_format(time,'%Y-%m-%d') as title,count(*) as imm_num from meter INNER JOIN user USING(time) WHERE meter.userId=user.id group by title order by title desc;
和 select date_format(time,'%Y-%m-%d') as title,count(*) as num WHERE 1=1 group by title order by title desc;
怎么合并成一条

Answer 1

可以用union 但你两条查询语句 查询的列不同