left join 用法
的有关信息介绍如下：
改成这样试试select a.cust_no,a.name,b.total from cust a left join (select cust_no,sum(TOT_NM_FOOD+TOT_NM_NFOOD+TOT_MM_FOOD+TOT_MM_NFOOD) as total from invoice group by cust_no) b on a.cust_no=b.cust_no
left join 用法
Simone
发布于 2026-04-20 21:48:38
846 阅读
