简单语句: select * from su_dept复合语句: select c.cust_sc_id,c.cust_name,c.cust_addr,c.contact,c.cont_tel,d.dept_id,d.dept_name,e.remain_money from ar_cust_info c,(select a.area_sect_id,b.dept_id,b.dept_name from mr_sect a,su_dept b where a.dept_id=b.dept_id and a.cust_type='111' and b.dept_id like '0211%' order by b.dept_id) d,chg_save_rema e where c.area_sect_id=d.area_sect_id and c.cust_id=e.cust_id and e.remain_money>'-150' and e.remain_money<'-50' order by e.remain_money
select * from su_dept复合语句:
select c.cust_sc_id,c.cust_name,c.cust_addr,c.contact,c.cont_tel,d.dept_id,d.dept_name,e.remain_money from ar_cust_info c,(select a.area_sect_id,b.dept_id,b.dept_name from mr_sect a,su_dept b where a.dept_id=b.dept_id and a.cust_type='111' and b.dept_id like '0211%' order by b.dept_id) d,chg_save_rema e where c.area_sect_id=d.area_sect_id and c.cust_id=e.cust_id and e.remain_money>'-150' and e.remain_money<'-50' order by e.remain_money