salix/db/versions/11342-crimsonDendro/02-itemShelving.sql

3 lines
115 B
SQL

UPDATE vn.itemShelving ish
JOIN tmp.tItemShelving tish ON tish.id = ish.id
SET ish.shelvingFk = tish.shelvingFk;