# 我以照伙提供的做,但.....

Posted by kkcheung on September 04, 1999 at 11:16:05:

In Reply to: Re: 可以说明join的用法吗? posted by SQL on September 04, 1999 at 02:26:02:

: Update Table1Name,Table2Name Set Table1Name.FieldValue=Table2Name.FieldValue Where Table1Name.RelationField = Table2Name.RelationField
: Table1Name.FieldValue为接受资料的栏位
: Table2Name.FieldValue为提供资料的栏位

照上面的语法,我写了下面的,你看对吗?
但我执行后是错的,可否出指出错在那里?先谢谢.
update sale_rec,receive_rec set sale_rec.send_code=receive_rec.send_code where sale_rec.invo_code='00009999' and sale_rec.stockno=receive_rec.stock_no

Follow Ups:

- Re: 我以照伙提供的做,但..... SQL 17:44:28 9/06/99 (0)