WEBVTT

1
00:00:00.000 --> 00:00:03.840
Instead of bringing back all rows
from both subsets like the union,

2
00:00:03.840 --> 00:00:07.670
the intersect is only going to
return the rows that exist in both.

3
00:00:08.790 --> 00:00:12.090
Let's see our sample union again.

4
00:00:12.090 --> 00:00:16.110
Here, it takes all products from
the electronics and furnished tables and

5
00:00:16.110 --> 00:00:17.970
creates one result set.

6
00:00:17.970 --> 00:00:22.795
If we perform an intersect on the same
two tables, we get no results back.

7
00:00:22.795 --> 00:00:26.014
[SOUND] This is because
that is no overlap.

8
00:00:26.014 --> 00:00:29.186
Let's add a piece of furniture
that we might want to market

9
00:00:29.186 --> 00:00:30.000
along with electronics, a TV stand.