MySQL INTERSECT Alternative: INNER JOIN

1 year ago
Benjamin Taylor
1 minute

In MySQL, intersect is not a native keyword or function. However, you can achieve similar functionality to intersect by using INNER JOIN to return records that exist in both tables simultaneously.

For example, suppose there are two tables A and B, and you want to return records that exist in both tables simultaneously, you can use the following statement:

SELECT * FROM A
INNER JOIN B ON A.column_name = B.column_name;

This will return the records that exist in both table A and table B at the same time.

bannerAds