MySQL常见的求交集、并集和差集
1、select a.*,b.* from tableA a left join tableB b on a.key = b.key;2、select a.*,b.* from tableA a right join tableB b on a.key = b.key;3、select a.*,b.* from tableA a inner join tableB b on a.key = b.key;4、select a.*,b.* from tableA a...
原创
2020-09-15 11:09:07 ·
883 阅读 ·
1 评论