主要介绍了MySQL不支持INTERSECT和MINUS情况下的替代方法,需要的朋友可以参考下

Doing INTERSECT and MINUS in MySQL Doing an INTERSECT An INTERSECT is simply an inner join where we compare the tuples of one table with those of the other, and select those that appear in both while weeding out duplicates. So 代码如下: SELECT member_id