selecta.FDate as DoSampleDate,t10.FDate as DoSampleRetDate,t5.FName,t3.FEmpName,sum(count(1)-case when t9.FSampleID is not null then 1 else 0 end) as 完成数,sum(case when t9.FSampleID is not null then 1 else 0 end) as 退回数
from Smp_doSample a
left outer join Smp_SampleTask t1 on t1.Finterid=a.FSampleid
left outer join Smp_SampleAllocEmp t2 on t2.FID=t1.Finterid
left outer join Basic_Employee t3 on t3.Finterid=t2.FEmpid
left outer join Smp_SampleEmp t4 on t4.FUserid=t3.Finterid
left outer join Smp_SampleDept t5 on t5.Finterid=t4.FGroupid
left outer join Basic_Cust t6 on t6.Finterid=a.FCustid
left outer join Basic_Item t7 on t7.Finterid=a.Fitemid
left outer join Basic_Color t8 on t8.Finterid=a.FColorid
left outer join Smp_DoSampleRetEntry t9 on t9.FDoSampleID=a.FInterID
left outer join Smp_DoSampleRet t10 on t10.FInterID=t9.FInterID
group by a.FDate,t5.FName,t3.FEmpName ,t9.FSampleID,t10.FDate
-->
这里有问题.