唉!Oralce弱智的两表关联更新问题

UPDATE wap_qd_web a SET a.month_1=(SELECT sf FROM wap_qd_web_1 b WHERE a.operator_id=b.org_id)  WHERE
EXISTS(SELECT sf FROM wap_qd_web_1 b WHERE a.operator_id=b.org_id );
posted on 2008-04-10 16:37  mingal  阅读(474)  评论(0编辑  收藏  举报