"SELECT tjmx.bph AS 部品号, tjmx.gys AS 供应商, SUM(tjmx.sl) AS 预用数量,SUM(vewsld.sls) AS 待检数量, SUM(vewsld.rks) AS 库存 FROM tjmx left JOIN vewsld ON tjmx.bph = vewsld.BPH and tjmx.gys=vewsld.bph GROUP BY tjmx.bph, tjmx.gys"
left JOIN 就是表间关联的命令格式。(这是左边联接)
full join 全部
right join 右联接
inner join 内联接
left JOIN 就是表间关联的命令格式。(这是左边联接)
full join 全部
right join 右联接
inner join 内联接
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货