主题：求助：打开窗体效率慢有什么更好的优化方法？(已解决)

 参考 http://www.foxtable.com/help/topics/1929.htm

Select top 20 * from 

(Select b.id, 生产单号,A.数量 As 订单数量,物料编码,B.数量 As 领料数量,A.MODID As MODID FROM {表1} A INNER JOIN {表3} B ON A.MODID=B.MODID) as tb1 

  where tb1.id > (select top 1 max(id) from (Select top 80 id from 

(Select d.id FROM {表1} c INNER JOIN {表3} d ON c.MODID=d.MODID))) 

order by tb1.id