SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE zo ( barcode_id int, barcode int ); CREATE TABLE sa ( barcode_id int, barcode int ); CREATE TABLE goods_barcode ( id serial, value varchar, version int, catalog_id int ); INSERT INTO goods_barcode VALUES (10, 'A', 5, 11), (11, 'A', 6, 11); UPDATE goods_barcode SET value = '#v' || value, "version" = (SELECT MAX("version") FROM goods_barcode) WHERE id NOT IN ( SELECT zo.barcode_id FROM zo INNER JOIN sa ON sa.barcode = zo.barcode ) AND catalog_id = 11; SELECT * FROM goods_barcode;