GBase8s数据库MERGE 语句的示例2

下一示例在 ON 子句中指定多个谓词：

MERGE INTO customer c

USING ext_customer e

ON c.customer_num=e.customer_num

AND c.fname=e.fname AND c.lname=e.lname

WHEN MATCHED THEN

UPDATE SET c.fname = e.fname,

c.lname = e.lname,

c.company = e.company,

c.address1 = e.address1,

c.address2 = e.address2,

c.city = e.city,

c.state = e.state,

c.zipcode = e.zipcode,

c.phone = e.phone

WHEN NOT MATCHED THEN

INSERT

(c.fname, c.lname, c.company, c.address1, c.address2,

c.city, c.state, c.zipcode, c.phone)

VALUES

(e.fname, e.lname, e.company, e.address1, e.address2,

e.city, e.state, e.zipcode, e.phone);