求一SQL语句 (MSSQL语句转换成MYSQL)
这里有两张表cwm_goods与cwm_order_goods
cwm_goods结构如下:
goods_id cost_price
100 300
101 310
102 320
cwm_order_goods结构如下:
recid goods_id cost_price
10 100
11 100
12 101
13 102
其中现在需要将cwm_order_goods表中的cost_price的值设为cwm_goods的goods_id对应的cost_price的值,按照MSSQL大概是这样的,我不知道MYSQL下要怎么翻译:
update `cwm_order_goods` set cost_price=(select cost_price from 'cwm_goods' where goods_id='cwm_order_goods'.goods_id) where recid>300