4 lines
203 B
MySQL
4 lines
203 B
MySQL
|
UPDATE IGNORE vn.entry e
|
||
|
|
JOIN vn.worker w ON w.code = TRIM(Right(REPLACE(e.notes, Char(10), ""), 4))
|
||
|
|
SET invoiceAmount = CAST(REPLACE(notes, ',', '.') as DECIMAL (10,2)),
|
||
|
|
buyerFk = w.id;
|