日期:2014-05-16  浏览次数:20576 次

集合差
insert into "SR"(sid, rid,is_parse) 
select * from 
(
	SELECT s.id as sid, r.id as rid,0 FROM "Segment" s ,"Rule" r where s.domain=r.domain order by sid,rid
) srall
where not exists (
	select 1 from "SR" sr where sr.sid=srall.sid and sr.rid=srall.rid
)