update ttt set ttt.QJZCBM=( select a.QJZCBM from j_gdgy a where a.ZZH =ttt.ZZHand a. JGBM=ttt.JGBM);update ttt set ttt.ZZBM=( select a.ZZBMfrom j_gdgy a where a.ZZH =ttt.ZZHand a. JGBM=ttt.JGBM); 上面两行UPdate只能操作 j_gdgy根据字段 a.ZZH =ttt.ZZHand a. JGBM=ttt.JGBM 返回的数据只有一行,如果返回多行记录的话的就不能这么执行了.如果是返回多行的话再联系我吧...
CREATE TABLE ASSELECT * FROM J_GDGY A,TTT BWHERE A.QJZCBM=B.QJZCBM(+)UNION ALLSELECT * FROM J_GDGY A,TTT BWHERE A.ZZBM=B.ZZBM(+);SELECT * FROM TTT GROUP BY 主键...