我要联合查询两张表,先将一个表进行group by 分组查询,再将查询结果left join另一张表。
select * from table_A a left join (
select filed ,count(1) counts from table_B group by filed
) b on a.filed=b.filed
结果报错,不能这样写。有哪位大神知道怎么解决吗?
我要联合查询两张表,先将一个表进行group by 分组查询,再将查询结果left join另一张表。
select * from table_A a left join (
select filed ,count(1) counts from table_B group by filed
) b on a.filed=b.filed
结果报错,不能这样写。有哪位大神知道怎么解决吗?