DEV Community

Fazlı Akça
Fazlı Akça

Posted on

PostgreSQL Merge Into

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

Enter fullscreen mode Exit fullscreen mode

Top comments (0)