SQL:
select i.zinv_id,i.zinv_model,ib.zinv_brand_desc,ic.zinv_class_desc,s.zcost_price,s.zprice
from co.inv i
left join co.inv_class_barnd icb on icb.zid = i.ZBRAND_CLASS_ID
left join co.zinv_class ic on ic.zinv_class_id = icb.zinv_class_id
left join co.inv_brand ib on ib.ZINV_BRAND_ID = icb.ZINV_BRAND_ID
inner join (select bd.zinv_id,isnull(ip.zcost_price,0) zcost_price,isnull(bd.zprice,0) zprice
from bill.wm.bill_dtl bd
left join bill.wm.bill b on b.zbill_id=bd.zbill_id and b.zcreat_dt between '2006-01-01 ' and '2006-01-30 '
left join pub_data.co.inv_price ip on bd.zinv_id=ip.zinv_id and ip.zset_dt between '2006-01-01 ' and '2006-01-30 '
where b.zbill_type_id=1 and b.zbill_status_id=1
group by bd.zinv_id , ip.zcost_price,bd.zprice
having min(isnull(ip.zcost_price,0))> min(isnull(bd.zprice,0))) s on s.zinv_id = i.zinv_id
where i.zstop_yn <> 1
查询效率的问题：
co.inv 产品表
co.inv_class_barnd 类别品牌中转表
co.zinv_class 产品类别表
co.inv_brand 产品品牌表
bill.wm.bill_dtl 单据体表
bill.wm.bill 单据头表
co.inv_price 产品价格表
select bd.zinv_id,isnull(ip.zcost_price,0) zcost_price,isnull(bd.zprice,0) zprice
from bill.wm.bill_dtl bd
left join bill.wm.bill b on b.zbill_id=bd.zbill_id and b.zcreat_dt between '2006-01-01 ' and '2006-01-30 '
left join pub_data.co.inv_price ip on bd.zinv_id=ip.zinv_id and ip.zset_dt between '2006-01-01 ' and '2006-01-30 '
where b.zbill_type_id=1 and b.zbill_status_id=1
group by bd.zinv_id , ip.zcost_price,bd.zprice
having min(isnull(ip.zcost_price,0))> min(isnull(bd.zprice,0))
查出产品报价大于单据体(销售出去的价格)的产品信息 (包含 产品id,报价,销售价)
现在这个sql的数据出来没有问题 不过就是很慢 有没有别的写法提高效率??
在页面上使用数据绑定控件会超时（asp.net）
------解决方案--------------------
暈,幫頂吧.
------解决方案--------------------
看着都累
------解决方案--------------------
多大的数据量？考虑用分页吧
------解决方案--------------------
好大一堆啊
试试 临时表 将步骤不解开了 不会超时
------解决方案--------------------
ajax can not reduce sql query time