select count(a.数量), count(b.数量), a.工作年, a.工作月,a.部门,a.组别,a.款号,a.工序,a.码数 from 工卡表 a 任务表 b where (a.工作年 = b.工作年) and (a.工作月 = b.工作月) and (a.工作年 = 指定年) and (a.工作月 = 指定月) and (a.部门 = b.部门) and (a.组别 = b.组别) and (a.款号 = b.款号) and (a.工序 = b.工序) and (a.码数 = b.码数)
from 工卡表 a 任务表 b
where
(a.工作年 = b.工作年) and
(a.工作月 = b.工作月) and
(a.工作年 = 指定年) and
(a.工作月 = 指定月) and
(a.部门 = b.部门) and
(a.组别 = b.组别) and
(a.款号 = b.款号) and
(a.工序 = b.工序) and
(a.码数 = b.码数)