sql merge 求高人

MERGE INTO GEN_STATISTICS gs
USING ( select dc.demo_id,dc.comparison,count(rx.custid) pNum from report_xx rx
join demo_character dc on rx.report_index = dc.comparison
and rx.unitid = dc.unit_id
and rx.projectid = dc.pro_id
where rx.report_index ='SEX001'
group by dc.demo_id,dc.comparison) rs
WHEN MATCHED THEN
UPDATE
SET
gs.demo_id = rx.demo_id,
gs.gen_name_id = rx.report_index

when not matched then
INSERT VALUES(
GEN_STATISTICS_SEQ.nextval,
dc.demo_id,
dc.gen_name_id,
count(rx.custid)

ORA-00969: missing ON keyword

using后要加on关键字 表述你这个表GEN_STATISTICS和子查询之间的关系 如果你理解的不是很透彻 不建议用merge into 还是分别判断用insert update比较保险

可以加条件， when matched then update set test_to.val = test_from.val where test_to.col='test'