能不能根据以上的两个table 来连接显示以下的成绩
------解决方案--------------------
- SQL code
select a.shiftid,a.[count],sum(case when b.system like 'cimpack%' then job else 0 end) as cimpack,sum(case when b.system like 'floortrack%' then job else 0 end) as floortrackfrom t1 inner joint t2 on t1.shiftid=b.shiftidgroup by a.shiftid,a.[count]