Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4
交集
select game_id from t1 where game_id not in (select t1.game_id from t1 left join t2 on t1.game_id = t2.game_id where t2.game_id is null);
差集
Select t1.game_id from t1 left join t2 using(game_id) where t2.game_id is null;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23682959/viewspace-631595/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23682959/viewspace-631595/