5 lines
222 B
MySQL
5 lines
222 B
MySQL
|
UPDATE vn.supplier s
|
||
|
|
JOIN vn.country c ON c.id = s.countryFk
|
||
|
|
SET s.nif = MID(REPLACE(s.nif, ' ', ''), 3, LENGTH(REPLACE(s.nif, ' ', '')) - 1)
|
||
|
|
WHERE s.isVies = TRUE
|
||
|
|
AND c.code = LEFT(REPLACE(s.nif, ' ', ''), 2);
|