mysql交集，并集

-- 交集
select table1.id,table2.name from video as table1 left join video as table2 using (name)
where table2.id is not null;

-- 并集，不重复
select name from video union select name from video2