日期:2014-05-16 浏览次数:20596 次
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 )