摘要: 支持CTE的复杂语句调用:原始调用SQL语句:with t as (select ma_id from sa_affair_info where ad_id=2203 and ai_affair_status=2 and ai_is_pass='true'),q as(select m.* from SA_Main_Affair m join t on t.ma_id=m.ma_index_no),p as (select ai.* from sa_affair_info ai join q on ai.ma_id=q.ma_id where ai_affair_status= 阅读全文
posted @ 2012-07-23 11:36 袁晓平 阅读(485) 评论(0) 推荐(0) 编辑