WEBVTT
Kind: captions
Language: en

00:00:00.740 --> 00:00:11.110 align:start position:0%
 
[Music]

00:00:11.110 --> 00:00:11.120 align:start position:0%
 
 

00:00:11.120 --> 00:00:13.220 align:start position:0%
 
we've<00:00:12.120><c> already</c><00:00:12.300><c> talked</c><00:00:12.660><c> about</c><00:00:12.750><c> how</c><00:00:12.900><c> to</c><00:00:13.080><c> create</c>

00:00:13.220 --> 00:00:13.230 align:start position:0%
we've already talked about how to create
 

00:00:13.230 --> 00:00:15.650 align:start position:0%
we've already talked about how to create
a<00:00:13.559><c> simple</c><00:00:13.889><c> query</c><00:00:14.190><c> that</c><00:00:14.460><c> only</c><00:00:14.639><c> uses</c><00:00:14.910><c> one</c><00:00:15.270><c> table</c>

00:00:15.650 --> 00:00:15.660 align:start position:0%
a simple query that only uses one table
 

00:00:15.660 --> 00:00:17.540 align:start position:0%
a simple query that only uses one table
but<00:00:16.170><c> queries</c><00:00:16.619><c> that</c><00:00:16.740><c> involve</c><00:00:16.980><c> more</c><00:00:17.310><c> than</c><00:00:17.369><c> one</c>

00:00:17.540 --> 00:00:17.550 align:start position:0%
but queries that involve more than one
 

00:00:17.550 --> 00:00:19.640 align:start position:0%
but queries that involve more than one
table<00:00:18.000><c> let</c><00:00:18.150><c> you</c><00:00:18.270><c> ask</c><00:00:18.450><c> much</c><00:00:18.840><c> more</c><00:00:18.869><c> interesting</c>

00:00:19.640 --> 00:00:19.650 align:start position:0%
table let you ask much more interesting
 

00:00:19.650 --> 00:00:21.769 align:start position:0%
table let you ask much more interesting
questions<00:00:20.070><c> to</c><00:00:20.250><c> your</c><00:00:20.340><c> database</c><00:00:20.610><c> now</c><00:00:21.360><c> this</c><00:00:21.599><c> also</c>

00:00:21.769 --> 00:00:21.779 align:start position:0%
questions to your database now this also
 

00:00:21.779 --> 00:00:23.390 align:start position:0%
questions to your database now this also
takes<00:00:22.050><c> a</c><00:00:22.230><c> little</c><00:00:22.470><c> bit</c><00:00:22.590><c> more</c><00:00:22.740><c> planning</c><00:00:23.009><c> than</c><00:00:23.369><c> a</c>

00:00:23.390 --> 00:00:23.400 align:start position:0%
takes a little bit more planning than a
 

00:00:23.400 --> 00:00:25.400 align:start position:0%
takes a little bit more planning than a
single<00:00:23.730><c> table</c><00:00:23.880><c> query</c><00:00:24.210><c> and</c><00:00:24.480><c> there</c><00:00:25.110><c> are</c><00:00:25.200><c> four</c>

00:00:25.400 --> 00:00:25.410 align:start position:0%
single table query and there are four
 

00:00:25.410 --> 00:00:26.839 align:start position:0%
single table query and there are four
steps<00:00:25.680><c> that</c><00:00:25.860><c> you</c><00:00:26.009><c> can</c><00:00:26.130><c> use</c><00:00:26.369><c> to</c><00:00:26.550><c> help</c><00:00:26.669><c> you</c>

00:00:26.839 --> 00:00:26.849 align:start position:0%
steps that you can use to help you
 

00:00:26.849 --> 00:00:29.870 align:start position:0%
steps that you can use to help you
design<00:00:27.119><c> it</c><00:00:27.329><c> the</c><00:00:28.320><c> first</c><00:00:28.560><c> step</c><00:00:28.860><c> is</c><00:00:29.070><c> pinpoint</c>

00:00:29.870 --> 00:00:29.880 align:start position:0%
design it the first step is pinpoint
 

00:00:29.880 --> 00:00:31.729 align:start position:0%
design it the first step is pinpoint
exactly<00:00:30.000><c> what</c><00:00:30.720><c> you</c><00:00:30.840><c> want</c><00:00:31.020><c> to</c><00:00:31.050><c> find</c><00:00:31.259><c> out</c><00:00:31.500><c> in</c>

00:00:31.729 --> 00:00:31.739 align:start position:0%
exactly what you want to find out in
 

00:00:31.739 --> 00:00:33.470 align:start position:0%
exactly what you want to find out in
other<00:00:32.220><c> words</c><00:00:32.430><c> which</c><00:00:32.790><c> question</c><00:00:33.270><c> are</c><00:00:33.390><c> you</c>

00:00:33.470 --> 00:00:33.480 align:start position:0%
other words which question are you
 

00:00:33.480 --> 00:00:35.990 align:start position:0%
other words which question are you
trying<00:00:33.750><c> to</c><00:00:33.810><c> answer</c><00:00:34.020><c> in</c><00:00:34.440><c> this</c><00:00:35.340><c> example</c><00:00:35.670><c> let's</c>

00:00:35.990 --> 00:00:36.000 align:start position:0%
trying to answer in this example let's
 

00:00:36.000 --> 00:00:37.970 align:start position:0%
trying to answer in this example let's
say<00:00:36.149><c> our</c><00:00:36.270><c> bakery</c><00:00:36.690><c> is</c><00:00:36.840><c> sending</c><00:00:37.170><c> out</c><00:00:37.260><c> coupons</c><00:00:37.680><c> to</c>

00:00:37.970 --> 00:00:37.980 align:start position:0%
say our bakery is sending out coupons to
 

00:00:37.980 --> 00:00:39.710 align:start position:0%
say our bakery is sending out coupons to
our<00:00:38.100><c> customers</c><00:00:38.579><c> who</c><00:00:38.700><c> live</c><00:00:38.880><c> outside</c><00:00:39.149><c> the</c><00:00:39.600><c> city</c>

00:00:39.710 --> 00:00:39.720 align:start position:0%
our customers who live outside the city
 

00:00:39.720 --> 00:00:41.720 align:start position:0%
our customers who live outside the city
limits<00:00:39.870><c> to</c><00:00:40.559><c> entice</c><00:00:40.860><c> them</c><00:00:41.070><c> to</c><00:00:41.130><c> come</c><00:00:41.370><c> back</c><00:00:41.550><c> to</c>

00:00:41.720 --> 00:00:41.730 align:start position:0%
limits to entice them to come back to
 

00:00:41.730 --> 00:00:43.939 align:start position:0%
limits to entice them to come back to
our<00:00:41.760><c> bakery</c><00:00:42.379><c> obviously</c><00:00:43.379><c> we</c><00:00:43.530><c> don't</c><00:00:43.710><c> want</c><00:00:43.890><c> to</c>

00:00:43.939 --> 00:00:43.949 align:start position:0%
our bakery obviously we don't want to
 

00:00:43.949 --> 00:00:45.349 align:start position:0%
our bakery obviously we don't want to
send<00:00:44.160><c> them</c><00:00:44.280><c> to</c><00:00:44.309><c> people</c><00:00:44.519><c> who</c><00:00:44.699><c> live</c><00:00:45.000><c> really</c><00:00:45.239><c> far</c>

00:00:45.349 --> 00:00:45.359 align:start position:0%
send them to people who live really far
 

00:00:45.359 --> 00:00:47.750 align:start position:0%
send them to people who live really far
away<00:00:45.809><c> we</c><00:00:46.410><c> just</c><00:00:46.440><c> want</c><00:00:46.800><c> to</c><00:00:46.859><c> focus</c><00:00:47.010><c> on</c><00:00:47.309><c> people</c><00:00:47.519><c> who</c>

00:00:47.750 --> 00:00:47.760 align:start position:0%
away we just want to focus on people who
 

00:00:47.760 --> 00:00:49.459 align:start position:0%
away we just want to focus on people who
live<00:00:47.910><c> relatively</c><00:00:48.480><c> close</c><00:00:48.660><c> to</c><00:00:49.050><c> Raleigh</c><00:00:49.260><c> and</c>

00:00:49.459 --> 00:00:49.469 align:start position:0%
live relatively close to Raleigh and
 

00:00:49.469 --> 00:00:51.619 align:start position:0%
live relatively close to Raleigh and
we're<00:00:50.460><c> also</c><00:00:50.550><c> just</c><00:00:50.820><c> going</c><00:00:51.030><c> to</c><00:00:51.149><c> send</c><00:00:51.359><c> them</c><00:00:51.510><c> to</c>

00:00:51.619 --> 00:00:51.629 align:start position:0%
we're also just going to send them to
 

00:00:51.629 --> 00:00:53.209 align:start position:0%
we're also just going to send them to
customers<00:00:51.780><c> who</c><00:00:52.199><c> have</c><00:00:52.350><c> previously</c><00:00:52.859><c> placed</c>

00:00:53.209 --> 00:00:53.219 align:start position:0%
customers who have previously placed
 

00:00:53.219 --> 00:00:55.700 align:start position:0%
customers who have previously placed
orders<00:00:53.670><c> at</c><00:00:53.820><c> our</c><00:00:53.940><c> bakery</c><00:00:54.140><c> the</c><00:00:55.140><c> customers</c><00:00:55.589><c> who</c>

00:00:55.700 --> 00:00:55.710 align:start position:0%
orders at our bakery the customers who
 

00:00:55.710 --> 00:00:56.989 align:start position:0%
orders at our bakery the customers who
meet<00:00:55.859><c> all</c><00:00:56.100><c> three</c><00:00:56.370><c> of</c><00:00:56.489><c> these</c><00:00:56.640><c> requirements</c>

00:00:56.989 --> 00:00:56.999 align:start position:0%
meet all three of these requirements
 

00:00:56.999 --> 00:00:59.630 align:start position:0%
meet all three of these requirements
will<00:00:57.329><c> receive</c><00:00:57.719><c> coupons</c><00:00:58.160><c> so</c><00:00:59.160><c> the</c><00:00:59.280><c> question</c>

00:00:59.630 --> 00:00:59.640 align:start position:0%
will receive coupons so the question
 

00:00:59.640 --> 00:01:01.430 align:start position:0%
will receive coupons so the question
that<00:00:59.760><c> we're</c><00:00:59.910><c> trying</c><00:00:59.940><c> to</c><00:01:00.239><c> answer</c><00:01:00.390><c> is</c><00:01:00.570><c> which</c>

00:01:01.430 --> 00:01:01.440 align:start position:0%
that we're trying to answer is which
 

00:01:01.440 --> 00:01:03.979 align:start position:0%
that we're trying to answer is which
customers<00:01:02.010><c> live</c><00:01:02.280><c> in</c><00:01:02.519><c> our</c><00:01:02.670><c> area</c><00:01:02.699><c> are</c><00:01:03.210><c> outside</c>

00:01:03.979 --> 00:01:03.989 align:start position:0%
customers live in our area are outside
 

00:01:03.989 --> 00:01:06.110 align:start position:0%
customers live in our area are outside
the<00:01:04.140><c> city</c><00:01:04.290><c> limits</c><00:01:04.739><c> and</c><00:01:04.860><c> have</c><00:01:05.610><c> placed</c><00:01:05.880><c> an</c><00:01:06.030><c> order</c>

00:01:06.110 --> 00:01:06.120 align:start position:0%
the city limits and have placed an order
 

00:01:06.120 --> 00:01:09.020 align:start position:0%
the city limits and have placed an order
at<00:01:06.390><c> our</c><00:01:06.420><c> bakery</c><00:01:07.159><c> the</c><00:01:08.159><c> second</c><00:01:08.520><c> step</c><00:01:08.730><c> is</c><00:01:09.000><c> to</c>

00:01:09.020 --> 00:01:09.030 align:start position:0%
at our bakery the second step is to
 

00:01:09.030 --> 00:01:11.120 align:start position:0%
at our bakery the second step is to
identify<00:01:09.300><c> the</c><00:01:09.870><c> information</c><00:01:10.560><c> that</c><00:01:10.740><c> we</c><00:01:10.890><c> need</c>

00:01:11.120 --> 00:01:11.130 align:start position:0%
identify the information that we need
 

00:01:11.130 --> 00:01:13.580 align:start position:0%
identify the information that we need
we'll<00:01:11.850><c> need</c><00:01:12.030><c> the</c><00:01:12.210><c> customers</c><00:01:12.630><c> names</c><00:01:12.930><c> and</c><00:01:13.259><c> their</c>

00:01:13.580 --> 00:01:13.590 align:start position:0%
we'll need the customers names and their
 

00:01:13.590 --> 00:01:16.010 align:start position:0%
we'll need the customers names and their
contact<00:01:14.009><c> information</c><00:01:14.280><c> and</c><00:01:14.729><c> in</c><00:01:15.570><c> order</c><00:01:15.780><c> to</c><00:01:15.869><c> know</c>

00:01:16.010 --> 00:01:16.020 align:start position:0%
contact information and in order to know
 

00:01:16.020 --> 00:01:17.420 align:start position:0%
contact information and in order to know
whether<00:01:16.259><c> they've</c><00:01:16.470><c> placed</c><00:01:16.799><c> an</c><00:01:16.979><c> order</c><00:01:17.100><c> at</c><00:01:17.399><c> our</c>

00:01:17.420 --> 00:01:17.430 align:start position:0%
whether they've placed an order at our
 

00:01:17.430 --> 00:01:19.190 align:start position:0%
whether they've placed an order at our
bakery<00:01:17.549><c> we'll</c><00:01:18.180><c> also</c><00:01:18.360><c> need</c><00:01:18.600><c> to</c><00:01:18.659><c> look</c><00:01:18.869><c> at</c><00:01:19.079><c> the</c>

00:01:19.190 --> 00:01:19.200 align:start position:0%
bakery we'll also need to look at the
 

00:01:19.200 --> 00:01:22.429 align:start position:0%
bakery we'll also need to look at the
order<00:01:19.380><c> ID</c><00:01:19.680><c> numbers</c><00:01:20.270><c> the</c><00:01:21.270><c> third</c><00:01:21.540><c> step</c><00:01:21.840><c> is</c><00:01:22.079><c> to</c>

00:01:22.429 --> 00:01:22.439 align:start position:0%
order ID numbers the third step is to
 

00:01:22.439 --> 00:01:24.200 align:start position:0%
order ID numbers the third step is to
locate<00:01:22.710><c> the</c><00:01:22.920><c> tables</c><00:01:23.130><c> that</c><00:01:23.729><c> contain</c><00:01:24.060><c> the</c>

00:01:24.200 --> 00:01:24.210 align:start position:0%
locate the tables that contain the
 

00:01:24.210 --> 00:01:26.600 align:start position:0%
locate the tables that contain the
information<00:01:24.719><c> that</c><00:01:24.869><c> we</c><00:01:24.990><c> need</c><00:01:25.229><c> in</c><00:01:25.469><c> this</c><00:01:26.399><c> case</c>

00:01:26.600 --> 00:01:26.610 align:start position:0%
information that we need in this case
 

00:01:26.610 --> 00:01:28.100 align:start position:0%
information that we need in this case
the<00:01:26.820><c> customers</c><00:01:27.240><c> names</c><00:01:27.570><c> and</c><00:01:27.899><c> contact</c>

00:01:28.100 --> 00:01:28.110 align:start position:0%
the customers names and contact
 

00:01:28.110 --> 00:01:30.139 align:start position:0%
the customers names and contact
information<00:01:28.500><c> are</c><00:01:29.070><c> stored</c><00:01:29.399><c> in</c><00:01:29.579><c> the</c><00:01:29.700><c> customers</c>

00:01:30.139 --> 00:01:30.149 align:start position:0%
information are stored in the customers
 

00:01:30.149 --> 00:01:32.359 align:start position:0%
information are stored in the customers
table<00:01:30.540><c> and</c><00:01:30.719><c> the</c><00:01:31.350><c> order</c><00:01:31.619><c> ID</c><00:01:31.770><c> numbers</c><00:01:32.219><c> are</c>

00:01:32.359 --> 00:01:32.369 align:start position:0%
table and the order ID numbers are
 

00:01:32.369 --> 00:01:34.639 align:start position:0%
table and the order ID numbers are
stored<00:01:32.579><c> in</c><00:01:32.820><c> the</c><00:01:32.939><c> orders</c><00:01:33.270><c> table</c><00:01:33.450><c> so</c><00:01:34.320><c> that</c><00:01:34.350><c> means</c>

00:01:34.639 --> 00:01:34.649 align:start position:0%
stored in the orders table so that means
 

00:01:34.649 --> 00:01:36.139 align:start position:0%
stored in the orders table so that means
we<00:01:34.799><c> need</c><00:01:34.950><c> both</c><00:01:35.189><c> of</c><00:01:35.219><c> these</c><00:01:35.490><c> tables</c><00:01:35.880><c> in</c><00:01:36.060><c> our</c>

00:01:36.139 --> 00:01:36.149 align:start position:0%
we need both of these tables in our
 

00:01:36.149 --> 00:01:39.020 align:start position:0%
we need both of these tables in our
query<00:01:36.509><c> at</c><00:01:37.250><c> this</c><00:01:38.250><c> point</c><00:01:38.520><c> we</c><00:01:38.700><c> have</c><00:01:38.820><c> enough</c>

00:01:39.020 --> 00:01:39.030 align:start position:0%
query at this point we have enough
 

00:01:39.030 --> 00:01:40.910 align:start position:0%
query at this point we have enough
information<00:01:39.329><c> to</c><00:01:39.719><c> start</c><00:01:39.960><c> creating</c><00:01:40.409><c> our</c><00:01:40.619><c> query</c>

00:01:40.910 --> 00:01:40.920 align:start position:0%
information to start creating our query
 

00:01:40.920 --> 00:01:44.209 align:start position:0%
information to start creating our query
go<00:01:41.909><c> to</c><00:01:41.969><c> the</c><00:01:42.210><c> create</c><00:01:42.420><c> tab</c><00:01:42.750><c> and</c><00:01:43.049><c> select</c><00:01:43.860><c> query</c>

00:01:44.209 --> 00:01:44.219 align:start position:0%
go to the create tab and select query
 

00:01:44.219 --> 00:01:46.520 align:start position:0%
go to the create tab and select query
design

00:01:46.520 --> 00:01:46.530 align:start position:0%
design
 

00:01:46.530 --> 00:01:48.800 align:start position:0%
design
we're<00:01:47.190><c> going</c><00:01:47.370><c> to</c><00:01:47.460><c> add</c><00:01:47.580><c> the</c><00:01:47.910><c> customers</c><00:01:48.450><c> table</c>

00:01:48.800 --> 00:01:48.810 align:start position:0%
we're going to add the customers table
 

00:01:48.810 --> 00:01:52.010 align:start position:0%
we're going to add the customers table
and<00:01:48.960><c> the</c><00:01:49.350><c> orders</c><00:01:49.710><c> table</c>

00:01:52.010 --> 00:01:52.020 align:start position:0%
 
 

00:01:52.020 --> 00:01:55.730 align:start position:0%
 
and<00:01:52.109><c> then</c><00:01:52.979><c> close</c><00:01:53.280><c> this</c><00:01:53.460><c> window</c>

00:01:55.730 --> 00:01:55.740 align:start position:0%
and then close this window
 

00:01:55.740 --> 00:02:00.130 align:start position:0%
and then close this window
you<00:01:55.980><c> can</c><00:01:56.130><c> resize</c><00:01:56.520><c> these</c><00:01:56.790><c> if</c><00:01:57.000><c> you</c><00:01:57.090><c> need</c><00:01:57.240><c> to</c>

00:02:00.130 --> 00:02:00.140 align:start position:0%
 
 

00:02:00.140 --> 00:02:02.170 align:start position:0%
 
then<00:02:00.710><c> we're</c><00:02:00.890><c> going</c><00:02:01.070><c> to</c><00:02:01.100><c> double</c><00:02:01.400><c> click</c><00:02:01.670><c> on</c><00:02:01.790><c> the</c>

00:02:02.170 --> 00:02:02.180 align:start position:0%
then we're going to double click on the
 

00:02:02.180 --> 00:02:04.330 align:start position:0%
then we're going to double click on the
fields<00:02:02.480><c> that</c><00:02:02.540><c> we</c><00:02:02.660><c> need</c><00:02:02.890><c> so</c><00:02:03.890><c> we'll</c><00:02:04.010><c> add</c><00:02:04.190><c> the</c>

00:02:04.330 --> 00:02:04.340 align:start position:0%
fields that we need so we'll add the
 

00:02:04.340 --> 00:02:07.150 align:start position:0%
fields that we need so we'll add the
customers<00:02:04.760><c> first</c><00:02:05.000><c> name</c><00:02:05.300><c> last</c><00:02:05.960><c> name</c><00:02:06.170><c> street</c>

00:02:07.150 --> 00:02:07.160 align:start position:0%
customers first name last name street
 

00:02:07.160 --> 00:02:12.220 align:start position:0%
customers first name last name street
address<00:02:07.280><c> city</c><00:02:07.850><c> state</c><00:02:08.920><c> zip</c><00:02:09.920><c> code</c><00:02:10.910><c> and</c><00:02:11.420><c> phone</c>

00:02:12.220 --> 00:02:12.230 align:start position:0%
address city state zip code and phone
 

00:02:12.230 --> 00:02:15.130 align:start position:0%
address city state zip code and phone
number<00:02:12.590><c> and</c><00:02:13.150><c> from</c><00:02:14.150><c> the</c><00:02:14.270><c> orders</c><00:02:14.600><c> table</c><00:02:14.780><c> we'll</c>

00:02:15.130 --> 00:02:15.140 align:start position:0%
number and from the orders table we'll
 

00:02:15.140 --> 00:02:18.370 align:start position:0%
number and from the orders table we'll
need<00:02:15.290><c> the</c><00:02:15.560><c> ID</c><00:02:15.830><c> field</c><00:02:16.870><c> when</c><00:02:17.870><c> you</c><00:02:17.960><c> have</c><00:02:18.140><c> more</c>

00:02:18.370 --> 00:02:18.380 align:start position:0%
need the ID field when you have more
 

00:02:18.380 --> 00:02:20.020 align:start position:0%
need the ID field when you have more
than<00:02:18.440><c> one</c><00:02:18.710><c> table</c><00:02:18.920><c> in</c><00:02:19.190><c> a</c><00:02:19.250><c> query</c><00:02:19.490><c> they</c><00:02:19.760><c> will</c><00:02:19.910><c> be</c>

00:02:20.020 --> 00:02:20.030 align:start position:0%
than one table in a query they will be
 

00:02:20.030 --> 00:02:22.390 align:start position:0%
than one table in a query they will be
joined<00:02:20.390><c> by</c><00:02:20.480><c> a</c><00:02:20.600><c> line</c><00:02:21.110><c> and</c><00:02:21.380><c> this</c><00:02:21.800><c> is</c><00:02:21.860><c> called</c><00:02:22.220><c> a</c>

00:02:22.390 --> 00:02:22.400 align:start position:0%
joined by a line and this is called a
 

00:02:22.400 --> 00:02:24.790 align:start position:0%
joined by a line and this is called a
join<00:02:22.760><c> the</c><00:02:23.510><c> join</c><00:02:23.750><c> will</c><00:02:23.930><c> often</c><00:02:24.290><c> have</c><00:02:24.470><c> an</c><00:02:24.620><c> arrow</c>

00:02:24.790 --> 00:02:24.800 align:start position:0%
join the join will often have an arrow
 

00:02:24.800 --> 00:02:26.320 align:start position:0%
join the join will often have an arrow
that<00:02:25.070><c> points</c><00:02:25.130><c> to</c><00:02:25.550><c> the</c><00:02:25.640><c> left</c><00:02:25.820><c> or</c><00:02:26.150><c> the</c><00:02:26.180><c> right</c>

00:02:26.320 --> 00:02:26.330 align:start position:0%
that points to the left or the right
 

00:02:26.330 --> 00:02:28.420 align:start position:0%
that points to the left or the right
which<00:02:27.110><c> tells</c><00:02:27.380><c> the</c><00:02:27.530><c> query</c><00:02:27.770><c> which</c><00:02:28.040><c> table</c><00:02:28.400><c> to</c>

00:02:28.420 --> 00:02:28.430 align:start position:0%
which tells the query which table to
 

00:02:28.430 --> 00:02:31.030 align:start position:0%
which tells the query which table to
look<00:02:28.730><c> at</c><00:02:28.880><c> first</c><00:02:29.530><c> sometimes</c><00:02:30.530><c> you'll</c><00:02:30.740><c> need</c><00:02:30.800><c> to</c>

00:02:31.030 --> 00:02:31.040 align:start position:0%
look at first sometimes you'll need to
 

00:02:31.040 --> 00:02:32.860 align:start position:0%
look at first sometimes you'll need to
change<00:02:31.250><c> the</c><00:02:31.550><c> direction</c><00:02:32.090><c> to</c><00:02:32.209><c> get</c><00:02:32.360><c> the</c><00:02:32.480><c> results</c>

00:02:32.860 --> 00:02:32.870 align:start position:0%
change the direction to get the results
 

00:02:32.870 --> 00:02:33.690 align:start position:0%
change the direction to get the results
that<00:02:33.020><c> you</c><00:02:33.140><c> want</c>

00:02:33.690 --> 00:02:33.700 align:start position:0%
that you want
 

00:02:33.700 --> 00:02:36.100 align:start position:0%
that you want
we're<00:02:34.700><c> going</c><00:02:34.880><c> to</c><00:02:35.060><c> double</c><00:02:35.450><c> click</c><00:02:35.630><c> on</c><00:02:35.810><c> the</c><00:02:35.930><c> join</c>

00:02:36.100 --> 00:02:36.110 align:start position:0%
we're going to double click on the join
 

00:02:36.110 --> 00:02:38.140 align:start position:0%
we're going to double click on the join
to<00:02:36.320><c> change</c><00:02:36.620><c> it</c><00:02:36.800><c> and</c><00:02:36.950><c> we</c><00:02:37.520><c> want</c><00:02:37.700><c> to</c><00:02:37.760><c> select</c><00:02:38.030><c> the</c>

00:02:38.140 --> 00:02:38.150 align:start position:0%
to change it and we want to select the
 

00:02:38.150 --> 00:02:40.420 align:start position:0%
to change it and we want to select the
third<00:02:38.510><c> option</c><00:02:38.780><c> which</c><00:02:39.080><c> says</c><00:02:39.410><c> include</c><00:02:40.130><c> all</c>

00:02:40.420 --> 00:02:40.430 align:start position:0%
third option which says include all
 

00:02:40.430 --> 00:02:42.760 align:start position:0%
third option which says include all
records<00:02:40.700><c> from</c><00:02:41.090><c> the</c><00:02:41.270><c> orders</c><00:02:41.300><c> table</c><00:02:41.750><c> and</c><00:02:42.110><c> in</c><00:02:42.680><c> the</c>

00:02:42.760 --> 00:02:42.770 align:start position:0%
records from the orders table and in the
 

00:02:42.770 --> 00:02:43.990 align:start position:0%
records from the orders table and in the
next<00:02:42.920><c> video</c><00:02:43.040><c> we're</c><00:02:43.340><c> going</c><00:02:43.459><c> to</c><00:02:43.550><c> talk</c><00:02:43.700><c> a</c><00:02:43.760><c> little</c>

00:02:43.990 --> 00:02:44.000 align:start position:0%
next video we're going to talk a little
 

00:02:44.000 --> 00:02:45.400 align:start position:0%
next video we're going to talk a little
more<00:02:44.120><c> about</c><00:02:44.450><c> why</c><00:02:44.750><c> we're</c><00:02:44.989><c> choosing</c><00:02:45.170><c> this</c>

00:02:45.400 --> 00:02:45.410 align:start position:0%
more about why we're choosing this
 

00:02:45.410 --> 00:02:47.560 align:start position:0%
more about why we're choosing this
option<00:02:45.590><c> but</c><00:02:46.310><c> basically</c><00:02:46.820><c> this</c><00:02:46.970><c> means</c><00:02:47.150><c> that</c><00:02:47.420><c> it</c>

00:02:47.560 --> 00:02:47.570 align:start position:0%
option but basically this means that it
 

00:02:47.570 --> 00:02:49.150 align:start position:0%
option but basically this means that it
will<00:02:47.690><c> pull</c><00:02:47.900><c> from</c><00:02:47.930><c> the</c><00:02:48.230><c> orders</c><00:02:48.560><c> table</c><00:02:48.739><c> first</c>

00:02:49.150 --> 00:02:49.160 align:start position:0%
will pull from the orders table first
 

00:02:49.160 --> 00:02:51.190 align:start position:0%
will pull from the orders table first
which<00:02:49.850><c> ensures</c><00:02:50.209><c> that</c><00:02:50.330><c> only</c><00:02:50.690><c> the</c><00:02:51.020><c> customers</c>

00:02:51.190 --> 00:02:51.200 align:start position:0%
which ensures that only the customers
 

00:02:51.200 --> 00:02:52.870 align:start position:0%
which ensures that only the customers
who<00:02:51.620><c> have</c><00:02:51.739><c> placed</c><00:02:51.980><c> an</c><00:02:52.190><c> order</c><00:02:52.370><c> will</c><00:02:52.730><c> be</c>

00:02:52.870 --> 00:02:52.880 align:start position:0%
who have placed an order will be
 

00:02:52.880 --> 00:02:55.570 align:start position:0%
who have placed an order will be
included<00:02:53.450><c> when</c><00:02:54.380><c> you</c><00:02:54.440><c> click</c><00:02:54.650><c> OK</c><00:02:54.980><c> you</c><00:02:55.040><c> can</c><00:02:55.220><c> see</c>

00:02:55.570 --> 00:02:55.580 align:start position:0%
included when you click OK you can see
 

00:02:55.580 --> 00:02:57.930 align:start position:0%
included when you click OK you can see
that<00:02:55.760><c> the</c><00:02:55.880><c> arrow</c><00:02:56.060><c> now</c><00:02:56.330><c> points</c><00:02:56.840><c> to</c><00:02:56.870><c> the</c><00:02:57.050><c> left</c>

00:02:57.930 --> 00:02:57.940 align:start position:0%
that the arrow now points to the left
 

00:02:57.940 --> 00:03:00.640 align:start position:0%
that the arrow now points to the left
the<00:02:58.940><c> fourth</c><00:02:59.209><c> step</c><00:02:59.510><c> is</c><00:02:59.720><c> to</c><00:02:59.810><c> determine</c><00:03:00.320><c> which</c>

00:03:00.640 --> 00:03:00.650 align:start position:0%
the fourth step is to determine which
 

00:03:00.650 --> 00:03:03.310 align:start position:0%
the fourth step is to determine which
search<00:03:01.010><c> criteria</c><00:03:01.640><c> you</c><00:03:01.730><c> need</c><00:03:02.000><c> to</c><00:03:02.150><c> use</c><00:03:02.360><c> we're</c>

00:03:03.310 --> 00:03:03.320 align:start position:0%
search criteria you need to use we're
 

00:03:03.320 --> 00:03:04.930 align:start position:0%
search criteria you need to use we're
going<00:03:03.500><c> to</c><00:03:03.590><c> be</c><00:03:03.680><c> adding</c><00:03:03.890><c> criteria</c><00:03:04.580><c> under</c><00:03:04.760><c> the</c>

00:03:04.930 --> 00:03:04.940 align:start position:0%
going to be adding criteria under the
 

00:03:04.940 --> 00:03:08.080 align:start position:0%
going to be adding criteria under the
city<00:03:05.330><c> and</c><00:03:05.600><c> phone</c><00:03:05.989><c> number</c><00:03:06.350><c> fields</c><00:03:06.760><c> first</c><00:03:07.760><c> we</c>

00:03:08.080 --> 00:03:08.090 align:start position:0%
city and phone number fields first we
 

00:03:08.090 --> 00:03:10.000 align:start position:0%
city and phone number fields first we
want<00:03:08.299><c> to</c><00:03:08.420><c> exclude</c><00:03:08.690><c> all</c><00:03:09.170><c> of</c><00:03:09.320><c> the</c><00:03:09.440><c> customers</c><00:03:09.860><c> who</c>

00:03:10.000 --> 00:03:10.010 align:start position:0%
want to exclude all of the customers who
 

00:03:10.010 --> 00:03:12.400 align:start position:0%
want to exclude all of the customers who
are<00:03:10.130><c> in</c><00:03:10.340><c> Raleigh</c><00:03:10.640><c> to</c><00:03:11.570><c> do</c><00:03:11.720><c> this</c><00:03:11.870><c> we're</c><00:03:12.110><c> going</c><00:03:12.140><c> to</c>

00:03:12.400 --> 00:03:12.410 align:start position:0%
are in Raleigh to do this we're going to
 

00:03:12.410 --> 00:03:15.610 align:start position:0%
are in Raleigh to do this we're going to
need<00:03:12.530><c> to</c><00:03:12.709><c> use</c><00:03:12.890><c> a</c><00:03:12.920><c> very</c><00:03:13.340><c> specific</c><00:03:13.670><c> syntax</c><00:03:14.620><c> so</c>

00:03:15.610 --> 00:03:15.620 align:start position:0%
need to use a very specific syntax so
 

00:03:15.620 --> 00:03:18.490 align:start position:0%
need to use a very specific syntax so
for<00:03:15.860><c> the</c><00:03:15.920><c> city</c><00:03:16.100><c> criteria</c><00:03:16.190><c> type</c><00:03:17.090><c> not</c><00:03:17.750><c> in</c><00:03:18.049><c> and</c>

00:03:18.490 --> 00:03:18.500 align:start position:0%
for the city criteria type not in and
 

00:03:18.500 --> 00:03:21.070 align:start position:0%
for the city criteria type not in and
then<00:03:19.340><c> in</c><00:03:19.459><c> parentheses</c><00:03:19.970><c> type</c><00:03:20.269><c> Raleigh</c><00:03:20.780><c> in</c>

00:03:21.070 --> 00:03:21.080 align:start position:0%
then in parentheses type Raleigh in
 

00:03:21.080 --> 00:03:23.580 align:start position:0%
then in parentheses type Raleigh in
quotation<00:03:21.830><c> marks</c>

00:03:23.580 --> 00:03:23.590 align:start position:0%
quotation marks
 

00:03:23.590 --> 00:03:25.530 align:start position:0%
quotation marks
and<00:03:23.680><c> you</c><00:03:24.129><c> can</c><00:03:24.280><c> use</c><00:03:24.400><c> the</c><00:03:24.550><c> syntax</c><00:03:25.000><c> whenever</c><00:03:25.360><c> you</c>

00:03:25.530 --> 00:03:25.540 align:start position:0%
and you can use the syntax whenever you
 

00:03:25.540 --> 00:03:27.270 align:start position:0%
and you can use the syntax whenever you
want<00:03:25.720><c> to</c><00:03:25.840><c> exclude</c><00:03:26.140><c> something</c><00:03:26.739><c> from</c><00:03:26.920><c> the</c><00:03:27.010><c> query</c>

00:03:27.270 --> 00:03:27.280 align:start position:0%
want to exclude something from the query
 

00:03:27.280 --> 00:03:30.509 align:start position:0%
want to exclude something from the query
results<00:03:28.019><c> now</c><00:03:29.019><c> we</c><00:03:29.080><c> also</c><00:03:29.349><c> need</c><00:03:29.709><c> some</c><00:03:30.099><c> way</c><00:03:30.129><c> of</c>

00:03:30.509 --> 00:03:30.519 align:start position:0%
results now we also need some way of
 

00:03:30.519 --> 00:03:32.430 align:start position:0%
results now we also need some way of
limiting<00:03:30.790><c> the</c><00:03:31.120><c> results</c><00:03:31.510><c> to</c><00:03:31.690><c> just</c><00:03:31.930><c> the</c><00:03:32.140><c> nearby</c>

00:03:32.430 --> 00:03:32.440 align:start position:0%
limiting the results to just the nearby
 

00:03:32.440 --> 00:03:34.500 align:start position:0%
limiting the results to just the nearby
towns<00:03:32.739><c> and</c><00:03:33.129><c> in</c><00:03:33.550><c> this</c><00:03:33.670><c> case</c><00:03:33.879><c> we're</c><00:03:34.120><c> going</c><00:03:34.269><c> to</c><00:03:34.360><c> do</c>

00:03:34.500 --> 00:03:34.510 align:start position:0%
towns and in this case we're going to do
 

00:03:34.510 --> 00:03:36.509 align:start position:0%
towns and in this case we're going to do
this<00:03:34.660><c> by</c><00:03:34.870><c> getting</c><00:03:34.930><c> the</c><00:03:35.319><c> area</c><00:03:35.709><c> code</c><00:03:35.950><c> from</c><00:03:36.310><c> the</c>

00:03:36.509 --> 00:03:36.519 align:start position:0%
this by getting the area code from the
 

00:03:36.519 --> 00:03:38.610 align:start position:0%
this by getting the area code from the
phone<00:03:36.700><c> number</c><00:03:36.970><c> field</c><00:03:37.170><c> the</c><00:03:38.170><c> nine</c><00:03:38.349><c> one</c><00:03:38.590><c> nine</c>

00:03:38.610 --> 00:03:38.620 align:start position:0%
phone number field the nine one nine
 

00:03:38.620 --> 00:03:40.890 align:start position:0%
phone number field the nine one nine
area<00:03:39.069><c> code</c><00:03:39.310><c> covers</c><00:03:39.670><c> Raleigh</c><00:03:39.940><c> and</c><00:03:40.330><c> a</c><00:03:40.540><c> number</c><00:03:40.780><c> of</c>

00:03:40.890 --> 00:03:40.900 align:start position:0%
area code covers Raleigh and a number of
 

00:03:40.900 --> 00:03:43.020 align:start position:0%
area code covers Raleigh and a number of
nearby<00:03:41.200><c> cities</c><00:03:41.560><c> and</c><00:03:41.709><c> towns</c><00:03:41.890><c> so</c><00:03:42.580><c> this</c><00:03:42.849><c> should</c>

00:03:43.020 --> 00:03:43.030 align:start position:0%
nearby cities and towns so this should
 

00:03:43.030 --> 00:03:45.509 align:start position:0%
nearby cities and towns so this should
give<00:03:43.150><c> us</c><00:03:43.330><c> a</c><00:03:43.420><c> pretty</c><00:03:43.629><c> good</c><00:03:43.750><c> range</c><00:03:44.250><c> will</c><00:03:45.250><c> need</c><00:03:45.400><c> to</c>

00:03:45.509 --> 00:03:45.519 align:start position:0%
give us a pretty good range will need to
 

00:03:45.519 --> 00:03:47.369 align:start position:0%
give us a pretty good range will need to
use<00:03:45.670><c> a</c><00:03:45.700><c> syntax</c><00:03:46.239><c> that</c><00:03:46.390><c> looks</c><00:03:46.690><c> at</c><00:03:46.870><c> the</c><00:03:47.019><c> beginning</c>

00:03:47.369 --> 00:03:47.379 align:start position:0%
use a syntax that looks at the beginning
 

00:03:47.379 --> 00:03:51.240 align:start position:0%
use a syntax that looks at the beginning
of<00:03:47.650><c> each</c><00:03:47.860><c> phone</c><00:03:48.220><c> number</c><00:03:48.580><c> so</c><00:03:49.269><c> type</c><00:03:49.510><c> like</c><00:03:50.110><c> and</c><00:03:50.410><c> in</c>

00:03:51.240 --> 00:03:51.250 align:start position:0%
of each phone number so type like and in
 

00:03:51.250 --> 00:03:54.080 align:start position:0%
of each phone number so type like and in
parentheses<00:03:51.879><c> type</c><00:03:52.299><c> quote</c><00:03:52.900><c> nine</c><00:03:53.379><c> one</c><00:03:53.620><c> nine</c>

00:03:54.080 --> 00:03:54.090 align:start position:0%
parentheses type quote nine one nine
 

00:03:54.090 --> 00:03:55.229 align:start position:0%
parentheses type quote nine one nine
asterisk

00:03:55.229 --> 00:03:55.239 align:start position:0%
asterisk
 

00:03:55.239 --> 00:03:58.440 align:start position:0%
asterisk
end<00:03:55.390><c> quote</c><00:03:56.230><c> the</c><00:03:57.220><c> asterisk</c><00:03:57.610><c> means</c><00:03:57.940><c> that</c><00:03:58.209><c> any</c>

00:03:58.440 --> 00:03:58.450 align:start position:0%
end quote the asterisk means that any
 

00:03:58.450 --> 00:04:00.300 align:start position:0%
end quote the asterisk means that any
phone<00:03:58.750><c> number</c><00:03:59.049><c> can</c><00:03:59.200><c> come</c><00:03:59.440><c> after</c><00:03:59.799><c> the</c><00:03:59.890><c> nine</c><00:04:00.099><c> one</c>

00:04:00.300 --> 00:04:00.310 align:start position:0%
phone number can come after the nine one
 

00:04:00.310 --> 00:04:02.789 align:start position:0%
phone number can come after the nine one
nine<00:04:00.370><c> area</c><00:04:00.910><c> code</c><00:04:01.150><c> and</c><00:04:01.360><c> there</c><00:04:02.260><c> are</c><00:04:02.380><c> many</c><00:04:02.590><c> other</c>

00:04:02.789 --> 00:04:02.799 align:start position:0%
nine area code and there are many other
 

00:04:02.799 --> 00:04:04.800 align:start position:0%
nine area code and there are many other
syntaxes<00:04:03.430><c> that</c><00:04:03.579><c> you</c><00:04:03.670><c> can</c><00:04:03.819><c> use</c><00:04:04.030><c> and</c><00:04:04.239><c> in</c><00:04:04.720><c> the</c>

00:04:04.800 --> 00:04:04.810 align:start position:0%
syntaxes that you can use and in the
 

00:04:04.810 --> 00:04:06.150 align:start position:0%
syntaxes that you can use and in the
next<00:04:04.989><c> video</c><00:04:05.110><c> we'll</c><00:04:05.440><c> look</c><00:04:05.530><c> at</c><00:04:05.620><c> a</c><00:04:05.680><c> few</c><00:04:05.769><c> other</c>

00:04:06.150 --> 00:04:06.160 align:start position:0%
next video we'll look at a few other
 

00:04:06.160 --> 00:04:08.940 align:start position:0%
next video we'll look at a few other
examples<00:04:06.370><c> of</c><00:04:06.849><c> these</c><00:04:07.200><c> now</c><00:04:08.200><c> in</c><00:04:08.349><c> this</c><00:04:08.470><c> case</c><00:04:08.680><c> we're</c>

00:04:08.940 --> 00:04:08.950 align:start position:0%
examples of these now in this case we're
 

00:04:08.950 --> 00:04:10.770 align:start position:0%
examples of these now in this case we're
putting<00:04:09.220><c> the</c><00:04:09.340><c> criteria</c><00:04:09.849><c> on</c><00:04:10.030><c> the</c><00:04:10.239><c> same</c><00:04:10.480><c> row</c>

00:04:10.770 --> 00:04:10.780 align:start position:0%
putting the criteria on the same row
 

00:04:10.780 --> 00:04:12.750 align:start position:0%
putting the criteria on the same row
because<00:04:11.530><c> we</c><00:04:11.680><c> want</c><00:04:11.890><c> the</c><00:04:11.980><c> customers</c><00:04:12.430><c> to</c><00:04:12.459><c> meet</c>

00:04:12.750 --> 00:04:12.760 align:start position:0%
because we want the customers to meet
 

00:04:12.760 --> 00:04:15.150 align:start position:0%
because we want the customers to meet
both<00:04:13.030><c> of</c><00:04:13.209><c> these</c><00:04:13.329><c> criteria</c><00:04:13.599><c> if</c><00:04:14.049><c> they</c><00:04:14.739><c> just</c><00:04:14.980><c> meet</c>

00:04:15.150 --> 00:04:15.160 align:start position:0%
both of these criteria if they just meet
 

00:04:15.160 --> 00:04:16.560 align:start position:0%
both of these criteria if they just meet
one<00:04:15.400><c> of</c><00:04:15.430><c> the</c><00:04:15.610><c> criteria</c><00:04:15.640><c> then</c><00:04:16.359><c> they're</c><00:04:16.479><c> not</c>

00:04:16.560 --> 00:04:16.570 align:start position:0%
one of the criteria then they're not
 

00:04:16.570 --> 00:04:17.940 align:start position:0%
one of the criteria then they're not
going<00:04:16.840><c> to</c><00:04:16.930><c> be</c><00:04:17.049><c> included</c><00:04:17.530><c> in</c><00:04:17.650><c> the</c><00:04:17.799><c> query</c>

00:04:17.940 --> 00:04:17.950 align:start position:0%
going to be included in the query
 

00:04:17.950 --> 00:04:20.520 align:start position:0%
going to be included in the query
results<00:04:18.519><c> if</c><00:04:18.669><c> we</c><00:04:19.269><c> needed</c><00:04:19.660><c> them</c><00:04:19.870><c> to</c><00:04:20.019><c> meet</c><00:04:20.169><c> one</c><00:04:20.410><c> or</c>

00:04:20.520 --> 00:04:20.530 align:start position:0%
results if we needed them to meet one or
 

00:04:20.530 --> 00:04:22.230 align:start position:0%
results if we needed them to meet one or
the<00:04:20.620><c> other</c><00:04:20.829><c> then</c><00:04:21.310><c> we</c><00:04:21.340><c> would</c><00:04:21.609><c> put</c><00:04:21.789><c> one</c><00:04:22.030><c> of</c><00:04:22.150><c> these</c>

00:04:22.230 --> 00:04:22.240 align:start position:0%
the other then we would put one of these
 

00:04:22.240 --> 00:04:25.740 align:start position:0%
the other then we would put one of these
criteria<00:04:22.840><c> on</c><00:04:23.020><c> the</c><00:04:23.169><c> next</c><00:04:23.470><c> row</c><00:04:24.210><c> this</c><00:04:25.210><c> query</c><00:04:25.539><c> is</c>

00:04:25.740 --> 00:04:25.750 align:start position:0%
criteria on the next row this query is
 

00:04:25.750 --> 00:04:28.020 align:start position:0%
criteria on the next row this query is
finished<00:04:26.110><c> now</c><00:04:26.289><c> so</c><00:04:26.860><c> we</c><00:04:27.100><c> can</c><00:04:27.280><c> run</c><00:04:27.490><c> it</c><00:04:27.610><c> to</c><00:04:27.760><c> see</c><00:04:27.910><c> the</c>

00:04:28.020 --> 00:04:28.030 align:start position:0%
finished now so we can run it to see the
 

00:04:28.030 --> 00:04:30.230 align:start position:0%
finished now so we can run it to see the
results

00:04:30.230 --> 00:04:30.240 align:start position:0%
 
 

00:04:30.240 --> 00:04:32.330 align:start position:0%
 
and<00:04:30.330><c> you</c><00:04:30.840><c> can</c><00:04:30.990><c> see</c><00:04:31.199><c> that</c><00:04:31.380><c> each</c><00:04:31.590><c> customer</c><00:04:31.889><c> meets</c>

00:04:32.330 --> 00:04:32.340 align:start position:0%
and you can see that each customer meets
 

00:04:32.340 --> 00:04:34.580 align:start position:0%
and you can see that each customer meets
both<00:04:32.610><c> criteria</c><00:04:32.780><c> they</c><00:04:33.780><c> are</c><00:04:33.960><c> not</c><00:04:34.139><c> from</c><00:04:34.349><c> Raleigh</c>

00:04:34.580 --> 00:04:34.590 align:start position:0%
both criteria they are not from Raleigh
 

00:04:34.590 --> 00:04:36.650 align:start position:0%
both criteria they are not from Raleigh
and<00:04:34.830><c> their</c><00:04:35.400><c> phone</c><00:04:35.550><c> numbers</c><00:04:35.880><c> begin</c><00:04:36.210><c> with</c><00:04:36.389><c> nine</c>

00:04:36.650 --> 00:04:36.660 align:start position:0%
and their phone numbers begin with nine
 

00:04:36.660 --> 00:04:39.350 align:start position:0%
and their phone numbers begin with nine
one<00:04:36.870><c> nine</c><00:04:37.460><c> so</c><00:04:38.460><c> generally</c><00:04:38.880><c> more</c><00:04:39.090><c> complex</c>

00:04:39.350 --> 00:04:39.360 align:start position:0%
one nine so generally more complex
 

00:04:39.360 --> 00:04:42.020 align:start position:0%
one nine so generally more complex
queries<00:04:39.990><c> require</c><00:04:40.380><c> more</c><00:04:40.680><c> planning</c><00:04:41.130><c> but</c><00:04:41.910><c> you</c>

00:04:42.020 --> 00:04:42.030 align:start position:0%
queries require more planning but you
 

00:04:42.030 --> 00:04:43.309 align:start position:0%
queries require more planning but you
can<00:04:42.150><c> make</c><00:04:42.270><c> it</c><00:04:42.330><c> a</c><00:04:42.479><c> lot</c><00:04:42.690><c> easier</c><00:04:43.080><c> by</c><00:04:43.289><c> just</c>

00:04:43.309 --> 00:04:43.319 align:start position:0%
can make it a lot easier by just
 

00:04:43.319 --> 00:04:46.070 align:start position:0%
can make it a lot easier by just
following<00:04:44.039><c> the</c><00:04:44.160><c> four</c><00:04:44.430><c> steps</c><00:04:44.759><c> of</c><00:04:45.080><c> pinpointing</c>

00:04:46.070 --> 00:04:46.080 align:start position:0%
following the four steps of pinpointing
 

00:04:46.080 --> 00:04:47.770 align:start position:0%
following the four steps of pinpointing
exactly<00:04:46.259><c> what</c><00:04:46.770><c> you</c><00:04:46.889><c> want</c><00:04:47.039><c> to</c><00:04:47.069><c> find</c><00:04:47.250><c> out</c>

00:04:47.770 --> 00:04:47.780 align:start position:0%
exactly what you want to find out
 

00:04:47.780 --> 00:04:49.820 align:start position:0%
exactly what you want to find out
identifying<00:04:48.780><c> the</c><00:04:48.960><c> information</c><00:04:49.560><c> that</c><00:04:49.710><c> you</c>

00:04:49.820 --> 00:04:49.830 align:start position:0%
identifying the information that you
 

00:04:49.830 --> 00:04:52.189 align:start position:0%
identifying the information that you
need<00:04:50.389><c> locating</c><00:04:51.389><c> the</c><00:04:51.509><c> tables</c><00:04:51.900><c> that</c><00:04:51.990><c> contain</c>

00:04:52.189 --> 00:04:52.199 align:start position:0%
need locating the tables that contain
 

00:04:52.199 --> 00:04:54.890 align:start position:0%
need locating the tables that contain
the<00:04:52.590><c> information</c><00:04:53.130><c> and</c><00:04:53.330><c> determining</c><00:04:54.330><c> exactly</c>

00:04:54.890 --> 00:04:54.900 align:start position:0%
the information and determining exactly
 

00:04:54.900 --> 00:04:57.800 align:start position:0%
the information and determining exactly
what<00:04:55.110><c> criteria</c><00:04:55.680><c> you</c><00:04:55.860><c> need</c><00:04:56.069><c> and</c><00:04:56.539><c> in</c><00:04:57.539><c> the</c><00:04:57.630><c> next</c>

00:04:57.800 --> 00:04:57.810 align:start position:0%
what criteria you need and in the next
 

00:04:57.810 --> 00:04:59.570 align:start position:0%
what criteria you need and in the next
video<00:04:57.990><c> we're</c><00:04:58.319><c> going</c><00:04:58.470><c> to</c><00:04:58.620><c> look</c><00:04:58.740><c> at</c><00:04:58.919><c> joins</c><00:04:59.250><c> and</c>

00:04:59.570 --> 00:04:59.580 align:start position:0%
video we're going to look at joins and
 

00:04:59.580 --> 00:05:01.460 align:start position:0%
video we're going to look at joins and
search<00:05:00.060><c> criteria</c><00:05:00.660><c> and</c><00:05:00.870><c> a</c><00:05:00.960><c> little</c><00:05:01.169><c> bit</c><00:05:01.319><c> more</c>

00:05:01.460 --> 00:05:01.470 align:start position:0%
search criteria and a little bit more
 

00:05:01.470 --> 00:05:06.610 align:start position:0%
search criteria and a little bit more
detail<00:05:04.220><c> like</c><00:05:05.220><c> what</c><00:05:05.400><c> you</c><00:05:05.550><c> just</c><00:05:05.580><c> saw</c>

00:05:06.610 --> 00:05:06.620 align:start position:0%
detail like what you just saw
 

00:05:06.620 --> 00:05:09.800 align:start position:0%
detail like what you just saw
radix<00:05:07.620><c> add</c><00:05:08.099><c> a</c><00:05:08.159><c> comment</c><00:05:08.699><c> subscribe</c><00:05:09.240><c> to</c><00:05:09.539><c> our</c>

00:05:09.800 --> 00:05:09.810 align:start position:0%
radix add a comment subscribe to our
 

00:05:09.810 --> 00:05:10.430 align:start position:0%
radix add a comment subscribe to our
Channel

00:05:10.430 --> 00:05:10.440 align:start position:0%
Channel
 

00:05:10.440 --> 00:05:13.019 align:start position:0%
Channel
the<00:05:11.280><c> freedom</c><00:05:11.699><c> to</c><00:05:11.729><c> learn</c>

00:05:13.019 --> 00:05:13.029 align:start position:0%
the freedom to learn
 

00:05:13.029 --> 00:05:18.239 align:start position:0%
the freedom to learn
what<00:05:13.659><c> you</c><00:05:13.869><c> want</c><00:05:14.339><c> when</c><00:05:15.339><c> you</c><00:05:15.369><c> want</c><00:05:17.249><c> absolutely</c>

00:05:18.239 --> 00:05:18.249 align:start position:0%
what you want when you want absolutely
 

00:05:18.249 --> 00:05:21.910 align:start position:0%
what you want when you want absolutely
free

00:05:21.910 --> 00:05:21.920 align:start position:0%
 
 

00:05:21.920 --> 00:05:25.550 align:start position:0%
 
GCF<00:05:22.920><c> learn</c><00:05:23.520><c> free.org</c>