04 2011 档案

sql 优化
摘要：select trim(store.odrim080_strid) odrim080_strid, trim(store.odrim080_strshowcd) || ' - ' || trim(store.odrim080_stracnm) odrim080_stracnm from odrim080_store storewhere 1 = 1 AND store.ODRIM080_STATUS = '1' and exists (select 1 from odrm023_autoset where store.odrim080_strid = odrm0 阅读全文
posted @ 2011-04-08 10:39 aspc 阅读(252) 评论(0) 推荐(0)