Syntax error How can INTERSECTION between tables be implemented with the help of MySQL joins?

How can INTERSECTION between tables be implemented with the help of MySQL joins?

Actually, INTERSECTION is just an inner join on all columns. We are taking a simple example of two tables, having the data as follows −

mysql> Select * from value1;
+------+------+
| i    | j    |
+------+------+
| 1    | 1    |
| 2    | 2    |
+------+------+
2 rows in set (0.00 sec)

mysql> Select * from value2;
+------+------+
| i    | j    |
+------+------+
| 1    | 1    |
| 3    | 3    |
+------+------+
2 rows in set (0.00 sec)

Now, the following query will do the INTERSECTION between these tables −

mysql> Select * from value1 join value2 using(i,j);
+------+------+
| i    | j    |
+------+------+
| 1    | 1    |
+------+------+
1 row in set (0.08 sec)
Updated on: 2020-06-20T11:16:54+05:30

133 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements