--你連關聯倏件都沒有,哥們你想做什麼 select mc.f_key,a.sum1,a.count1 from zhangwl.c_sa sa, zhangwl.c_sa fsa, zhangwl.c_MC mc, (select sum(sa.f_receivetime-fsa.f_issuetime) sum1,count(sa.f_receivetime-fsa.f_issuetime)count1 from zhangwl.cr_lwms_sa) a group by mc.f_key;
--你連關聯倏件都沒有,哥們你想做什麼
select mc.f_key,a.sum1,a.count1
from
zhangwl.c_sa sa,
zhangwl.c_sa fsa,
zhangwl.c_MC mc,
(select sum(sa.f_receivetime-fsa.f_issuetime) sum1,count(sa.f_receivetime-fsa.f_issuetime)count1
from zhangwl.cr_lwms_sa) a
group by mc.f_key;