1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | UPDATE contractnotice SET "supplierABN" = subquery."supplierABN" FROM (SELECT "CNID", a."supplierABN" FROM contractnotice INNER JOIN (SELECT text_mode("supplierABN") AS "supplierABN", lower(regexp_replace("supplierName",'[,\.]','', 'g')) AS name FROM contractnotice WHERE "supplierABN" IS NOT NULL GROUP BY name) a ON lower(regexp_replace("supplierName",'[,\.]','', 'g')) = name WHERE contractnotice."supplierABN" IS NULL) AS subquery WHERE contractnotice."CNID" = subquery."CNID"; |