更新bank表中的address字段，通过bank.tyid与banktype的typeid进行关联
update bank set address = (select typename from banktype where bank.tyid=banktype.typeid)
更新bank表中的address字段，通过bank.tyid与banktype的typeid进行关联
update bank set address = (select typename from banktype where bank.tyid=banktype.typeid)
This entry was posted on 2010-05-25, 09:51 and is filed under oracle. You can follow any responses to this entry through RSS 2.0. You can leave a response, or trackback from your own site.
You must be logged in to post a comment.
Arclite theme by digitalnature | powered by WordPress