GBase8s数据库MERGE 语句的示例3

下列 MERGE 语句执行 Update 结合，不带 Insert 子句：

MERGE INTO customer c

USING ext_customer e

ON c.customer_num=e.customer_num

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 ;

下列 MERGE 语句仅在结合条件之后包括 Delete 子句：

MERGE INTO customer c

USING ext_customer e

ON c.customer_num=e.customer_num

WHEN MATCHED THEN

DELETE ;