18 lines
826 B
HTML
18 lines
826 B
HTML
<div id="sina_keyword_ad_area2" class="articalContent ">
|
|
<div>SQL语法</div>
|
|
<div>update 表1 set 字段1 = bb.字段1 from 表1 as aa,</div>
|
|
<div>(select 字段1,字段2 from 表2) bb where aa.字段2 = bb.字段2</div>
|
|
<div> </div>
|
|
<div>update t1 set t1.字段1= t2.字段1</div>
|
|
<div>
|
|
<p><em id="__mceDel">from [表1] t1<br />inner join [表2] t2 on t1.字段= t2.字段<br />where t2.字段 = ''</em></p>
|
|
</div>
|
|
<div> </div>
|
|
<div> </div>
|
|
<div>Access语法</div>
|
|
<div>update <span style="line-height: 21px;">表1 </span>as a ,<span style="line-height: 21px;">表</span><span style="line-height: 21px;">2</span> as b set
|
|
a.<span style="line-height: 21px;">字段1</span>= b.<span style="line-height: 21px;">字段1 </span>where
|
|
a.StuNo=b.StuNo</div>
|
|
|
|
</div>
|
|
<p> </p> |