UPDATE PSMT_INVOICE_M
SET SHIPPING_COUNTRY_ID = SRC.COUNTRY_ID,
SHIPPING_CITY_ID = SRC.CITY_ID,
SHIPPING_TOWN_ID = SRC.TOWN_ID
FROM ( SELECT
PM.INVOICE_M_ID,
FE.COUNTRY_ID,
FE.CITY_ID,
FE.TOWN_ID
FROM PSMT_INVOICE_M PM
JOIN FIND_ENTITY FE ON PM.ENTITY_ID = FE.ENTITY_ID
) SRC
WHERE PSMT_INVOICE_M.INVOICE_M_ID = SRC.INVOICE_M_ID
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)