56,677
社区成员
发帖
与我相关
我的任务
分享
select sum(B.num) as s_num,A.sku
from A
inner join B
on left(B.sku,1) = A.sku
where 条件
group by A.sku
是要这个效果?那我怎么获取SKU为A的数量(B表中A1 A2算A的子SKU) 然后select sum(num) as s_num where sku like 'A%'
我现在是先select * from sku