语法:Update a表 Set a表.字段=b表.字段 from a,b(注:b表可以是从某表中过滤查询生成的临时表) where 外键可以关联的字段 and 条件 update CorpInfo set CorpInfo.SimpleName = Company.GONGSIJC, CorpInfo.CorpName = Company.GONGSIQC from CorpInfo,(SELECTRIGHT(JIGOUBM, 6) AS Code,GONGSIJC,GONGSIQC FROM Company_Info)as Company where CorpInfo.Code = Company.Code
posted on
2007-02-01 11:33Gary.han
阅读(4053)
评论(0)
编辑收藏举报