DackRen
1/14/2019 - 1:19 PM

complete shipments.checked_at by account_stated and complete account_stated.transporter by shipments.transporter

complete shipments.checked_at by account_stated and complete account_stated.transporter by shipments.transporter

sql0.sql
content_copyfile_download
UPDATE shipments set checkedat = to_timestamp(account_stated."month", 'YYYY-MM') FROM account_stated WHERE shipments.id = account_stated.reference and shipments.checkedat is null

UPDATE account_stated set transporter = shipments.transporter FROM shipments WHERE shipments.id = account_stated.reference