我现在要达到上图中显示的结果. 请教各位大人DB要如何设计才能最优的达到这个目的呢? 谢谢 真快.............. 进行连接查询即可，在连接字段上建立索引 SQL code: --2 select t.*, (select sum(case isnull([担当者ID2],'') when '' then [契约金额] else [契约金额]/2 end) from [契约表] where [担当者ID1] = t.[担当者ID] or [担当者ID2] = t.[担当者ID]) as 业绩 from [担当者表] t
第一句: select ht.gfdm,gfdm.gfmc,gfdm.lb ,sum(jh.htdj*jh.htsl)as je from ht left join gfdm on ht.gfdm=gfdm.gfdm join jh on ht.htbh=jh.hth and ht.htbh not like'del%' and ht. ......
