-- 交集 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