WEBVTT

1
00:00:01.050 --> 00:00:05.510
A join is a way we instruct a database
to combine the data from two or

2
00:00:05.510 --> 00:00:08.220
more tables in one result set.

3
00:00:08.220 --> 00:00:10.630
There are different types of joins.

4
00:00:10.630 --> 00:00:13.877
The two most common are inner join and
outer join.

5
00:00:13.877 --> 00:00:16.314
We have more information on these and

6
00:00:16.314 --> 00:00:19.389
other types of joins in
the teacher's notes.

7
00:00:19.389 --> 00:00:24.262
Queries with more than one table
joined together using inner joins will

8
00:00:24.262 --> 00:00:27.276
only return matching data in all join tables.

9
00:00:27.276 --> 00:00:30.000
The JOIN clause always
follows FROM in your query.