Update Statement with Other Table
呢排為設置 Testing 場而預備緊 d SQL statement, 有部份 Data 得 detail table, 但使用時要整返個 master 比佢, 所以就要使用 update statement 黎 link 返唔同 table 既 key, 以下係一個例子:
update tblModel set series_pkey = tblSeries.pkey from tblModel, tblSeries where tblSeries.full_name = 'A Series' and tblModel.full_name like 'A %';
Tags: sql
