链接两个table解决思路

链接两个table


能不能根据以上的两个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]