WEBVTT
Kind: captions
Language: en

00:00:01.180 --> 00:00:03.729 align:start position:0%
 
Goodwill<00:00:02.180><c> Community</c><00:00:02.629><c> Foundation</c><00:00:03.290><c> creating</c>

00:00:03.729 --> 00:00:03.739 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.739 --> 00:00:08.110 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.340><c> for</c><00:00:04.550><c> a</c><00:00:04.610><c> better</c><00:00:04.640><c> life</c><00:00:07.120><c> we've</c>

00:00:08.110 --> 00:00:08.120 align:start position:0%
opportunities for a better life we've
 

00:00:08.120 --> 00:00:09.549 align:start position:0%
opportunities for a better life we've
already<00:00:08.300><c> talked</c><00:00:08.660><c> about</c><00:00:08.749><c> how</c><00:00:08.900><c> to</c><00:00:09.110><c> create</c><00:00:09.259><c> a</c>

00:00:09.549 --> 00:00:09.559 align:start position:0%
already talked about how to create a
 

00:00:09.559 --> 00:00:11.650 align:start position:0%
already talked about how to create a
simple<00:00:09.919><c> query</c><00:00:10.190><c> that</c><00:00:10.429><c> only</c><00:00:10.490><c> uses</c><00:00:11.059><c> one</c><00:00:11.269><c> table</c>

00:00:11.650 --> 00:00:11.660 align:start position:0%
simple query that only uses one table
 

00:00:11.660 --> 00:00:13.539 align:start position:0%
simple query that only uses one table
but<00:00:12.169><c> queries</c><00:00:12.620><c> that</c><00:00:12.740><c> involve</c><00:00:12.980><c> more</c><00:00:13.339><c> than</c><00:00:13.369><c> one</c>

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

00:00:13.549 --> 00:00:15.640 align:start position:0%
but queries that involve more than one
table<00:00:13.999><c> let</c><00:00:14.150><c> you</c><00:00:14.269><c> ask</c><00:00:14.419><c> much</c><00:00:14.869><c> more</c><00:00:14.900><c> interesting</c>

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

00:00:15.650 --> 00:00:17.950 align:start position:0%
table let you ask much more interesting
questions<00:00:16.100><c> to</c><00:00:16.190><c> your</c><00:00:16.340><c> database</c><00:00:16.630><c> now</c><00:00:17.630><c> this</c><00:00:17.779><c> also</c>

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

00:00:17.960 --> 00:00:19.599 align:start position:0%
questions to your database now this also
takes<00:00:18.260><c> a</c><00:00:18.439><c> little</c><00:00:18.590><c> bit</c><00:00:18.769><c> more</c><00:00:18.920><c> planning</c><00:00:19.189><c> than</c><00:00:19.429><c> a</c>

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

00:00:19.609 --> 00:00:21.609 align:start position:0%
takes a little bit more planning than a
single<00:00:19.939><c> table</c><00:00:20.090><c> query</c><00:00:20.449><c> and</c><00:00:20.689><c> there</c><00:00:21.289><c> are</c><00:00:21.380><c> four</c>

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

00:00:21.619 --> 00:00:23.050 align:start position:0%
single table query and there are four
steps<00:00:21.949><c> that</c><00:00:22.070><c> you</c><00:00:22.189><c> can</c><00:00:22.340><c> use</c><00:00:22.580><c> to</c><00:00:22.759><c> help</c><00:00:22.849><c> you</c>

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

00:00:23.060 --> 00:00:26.050 align:start position:0%
steps that you can use to help you
design<00:00:23.359><c> it</c><00:00:23.539><c> the</c><00:00:24.500><c> first</c><00:00:24.769><c> step</c><00:00:25.070><c> is</c><00:00:25.250><c> pinpoint</c>

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

00:00:26.060 --> 00:00:27.849 align:start position:0%
design it the first step is pinpoint
exactly<00:00:26.179><c> what</c><00:00:26.900><c> you</c><00:00:27.019><c> want</c><00:00:27.199><c> to</c><00:00:27.230><c> find</c><00:00:27.410><c> out</c>

00:00:27.849 --> 00:00:27.859 align:start position:0%
exactly what you want to find out
 

00:00:27.859 --> 00:00:29.679 align:start position:0%
exactly what you want to find out
in<00:00:27.919><c> other</c><00:00:28.400><c> words</c><00:00:28.640><c> which</c><00:00:29.000><c> question</c><00:00:29.480><c> are</c><00:00:29.570><c> you</c>

00:00:29.679 --> 00:00:29.689 align:start position:0%
in other words which question are you
 

00:00:29.689 --> 00:00:32.170 align:start position:0%
in other words which question are you
trying<00:00:29.960><c> to</c><00:00:30.019><c> answer</c><00:00:30.230><c> in</c><00:00:30.650><c> this</c><00:00:31.519><c> example</c><00:00:31.849><c> let's</c>

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

00:00:32.180 --> 00:00:34.180 align:start position:0%
trying to answer in this example let's
say<00:00:32.329><c> our</c><00:00:32.450><c> bakery</c><00:00:32.870><c> is</c><00:00:33.020><c> sending</c><00:00:33.350><c> out</c><00:00:33.440><c> coupons</c><00:00:33.860><c> to</c>

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

00:00:34.190 --> 00:00:35.799 align:start position:0%
say our bakery is sending out coupons to
our<00:00:34.280><c> customers</c><00:00:34.760><c> who</c><00:00:34.910><c> live</c><00:00:35.059><c> outside</c><00:00:35.360><c> the</c><00:00:35.629><c> city</c>

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

00:00:35.809 --> 00:00:37.900 align:start position:0%
our customers who live outside the city
limits<00:00:36.410><c> to</c><00:00:36.739><c> entice</c><00:00:37.039><c> them</c><00:00:37.280><c> to</c><00:00:37.309><c> come</c><00:00:37.550><c> back</c><00:00:37.730><c> to</c>

00:00:37.900 --> 00:00:37.910 align:start position:0%
limits to entice them to come back to
 

00:00:37.910 --> 00:00:40.330 align:start position:0%
limits to entice them to come back to
our<00:00:37.940><c> bakery</c><00:00:38.739><c> obviously</c><00:00:39.739><c> we</c><00:00:39.920><c> don't</c><00:00:40.039><c> want</c><00:00:40.160><c> to</c>

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

00:00:40.340 --> 00:00:41.920 align:start position:0%
our bakery obviously we don't want to
send<00:00:40.520><c> them</c><00:00:40.670><c> to</c><00:00:40.789><c> people</c><00:00:40.910><c> who</c><00:00:41.090><c> live</c><00:00:41.360><c> really</c><00:00:41.719><c> far</c>

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

00:00:41.930 --> 00:00:44.139 align:start position:0%
send them to people who live really far
away<00:00:42.020><c> we</c><00:00:42.800><c> just</c><00:00:42.829><c> want</c><00:00:43.190><c> to</c><00:00:43.250><c> focus</c><00:00:43.370><c> on</c><00:00:43.699><c> people</c><00:00:43.879><c> who</c>

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

00:00:44.149 --> 00:00:45.880 align:start position:0%
away we just want to focus on people who
live<00:00:44.300><c> relatively</c><00:00:44.870><c> close</c><00:00:45.020><c> to</c><00:00:45.410><c> Raleigh</c><00:00:45.620><c> and</c>

00:00:45.880 --> 00:00:45.890 align:start position:0%
live relatively close to Raleigh and
 

00:00:45.890 --> 00:00:47.860 align:start position:0%
live relatively close to Raleigh and
we're<00:00:46.699><c> also</c><00:00:46.789><c> just</c><00:00:47.120><c> going</c><00:00:47.300><c> to</c><00:00:47.390><c> send</c><00:00:47.629><c> them</c><00:00:47.750><c> to</c>

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

00:00:47.870 --> 00:00:49.420 align:start position:0%
we're also just going to send them to
customers<00:00:48.020><c> who</c><00:00:48.469><c> have</c><00:00:48.590><c> previously</c><00:00:49.190><c> placed</c>

00:00:49.420 --> 00:00:49.430 align:start position:0%
customers who have previously placed
 

00:00:49.430 --> 00:00:52.000 align:start position:0%
customers who have previously placed
orders<00:00:49.879><c> at</c><00:00:50.059><c> our</c><00:00:50.149><c> bakery</c><00:00:50.440><c> the</c><00:00:51.440><c> customers</c><00:00:51.890><c> who</c>

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

00:00:52.010 --> 00:00:53.319 align:start position:0%
orders at our bakery the customers who
meet<00:00:52.190><c> all</c><00:00:52.370><c> three</c><00:00:52.699><c> of</c><00:00:52.789><c> these</c><00:00:52.910><c> requirements</c>

00:00:53.319 --> 00:00:53.329 align:start position:0%
meet all three of these requirements
 

00:00:53.329 --> 00:00:56.139 align:start position:0%
meet all three of these requirements
will<00:00:53.690><c> receive</c><00:00:54.019><c> coupons</c><00:00:54.670><c> so</c><00:00:55.670><c> the</c><00:00:55.789><c> question</c>

00:00:56.139 --> 00:00:56.149 align:start position:0%
will receive coupons so the question
 

00:00:56.149 --> 00:00:57.939 align:start position:0%
will receive coupons so the question
that<00:00:56.239><c> we're</c><00:00:56.390><c> trying</c><00:00:56.420><c> to</c><00:00:56.690><c> answer</c><00:00:56.870><c> is</c><00:00:57.079><c> which</c>

00:00:57.939 --> 00:00:57.949 align:start position:0%
that we're trying to answer is which
 

00:00:57.949 --> 00:01:00.490 align:start position:0%
that we're trying to answer is which
customers<00:00:58.519><c> live</c><00:00:58.789><c> in</c><00:00:59.030><c> our</c><00:00:59.179><c> area</c><00:00:59.210><c> are</c><00:00:59.690><c> outside</c>

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

00:01:00.500 --> 00:01:02.619 align:start position:0%
customers live in our area are outside
the<00:01:00.620><c> city</c><00:01:00.769><c> limits</c><00:01:00.920><c> and</c><00:01:01.429><c> have</c><00:01:02.120><c> placed</c><00:01:02.359><c> an</c><00:01:02.510><c> order</c>

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

00:01:02.629 --> 00:01:05.980 align:start position:0%
the city limits and have placed an order
at<00:01:02.780><c> our</c><00:01:02.929><c> bakery</c><00:01:03.850><c> the</c><00:01:04.850><c> second</c><00:01:05.239><c> step</c><00:01:05.449><c> is</c><00:01:05.659><c> to</c>

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

00:01:05.990 --> 00:01:07.960 align:start position:0%
at our bakery the second step is to
identify<00:01:06.170><c> the</c><00:01:06.590><c> information</c><00:01:06.830><c> that</c><00:01:07.430><c> we</c><00:01:07.580><c> need</c>

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

00:01:07.970 --> 00:01:10.270 align:start position:0%
identify the information that we need
we'll<00:01:08.570><c> need</c><00:01:08.720><c> the</c><00:01:08.900><c> customers</c><00:01:09.320><c> names</c><00:01:09.619><c> and</c><00:01:09.950><c> their</c>

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

00:01:10.280 --> 00:01:12.700 align:start position:0%
we'll need the customers names and their
contact<00:01:10.700><c> information</c><00:01:10.970><c> and</c><00:01:11.420><c> in</c><00:01:12.259><c> order</c><00:01:12.470><c> to</c><00:01:12.560><c> know</c>

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

00:01:12.710 --> 00:01:14.080 align:start position:0%
contact information and in order to know
whether<00:01:12.920><c> they've</c><00:01:13.159><c> placed</c><00:01:13.460><c> an</c><00:01:13.670><c> order</c><00:01:13.790><c> at</c><00:01:13.970><c> our</c>

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

00:01:14.090 --> 00:01:15.880 align:start position:0%
whether they've placed an order at our
bakery<00:01:14.240><c> we'll</c><00:01:14.869><c> also</c><00:01:15.049><c> need</c><00:01:15.290><c> to</c><00:01:15.409><c> look</c><00:01:15.560><c> at</c><00:01:15.710><c> the</c>

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

00:01:15.890 --> 00:01:19.210 align:start position:0%
bakery we'll also need to look at the
order<00:01:16.040><c> ID</c><00:01:16.369><c> numbers</c><00:01:17.350><c> the</c><00:01:18.350><c> third</c><00:01:18.619><c> step</c><00:01:18.920><c> is</c><00:01:19.159><c> to</c>

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

00:01:19.220 --> 00:01:21.310 align:start position:0%
order ID numbers the third step is to
locate<00:01:19.790><c> the</c><00:01:20.180><c> tables</c><00:01:20.360><c> that</c><00:01:20.810><c> contain</c><00:01:20.930><c> the</c>

00:01:21.310 --> 00:01:21.320 align:start position:0%
locate the tables that contain the
 

00:01:21.320 --> 00:01:23.770 align:start position:0%
locate the tables that contain the
information<00:01:21.890><c> that</c><00:01:22.070><c> we</c><00:01:22.189><c> need</c><00:01:22.400><c> in</c><00:01:22.610><c> this</c><00:01:23.540><c> case</c>

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

00:01:23.780 --> 00:01:25.270 align:start position:0%
information that we need in this case
the<00:01:23.960><c> customers</c><00:01:24.409><c> names</c><00:01:24.710><c> and</c><00:01:25.040><c> contact</c>

00:01:25.270 --> 00:01:25.280 align:start position:0%
the customers names and contact
 

00:01:25.280 --> 00:01:27.280 align:start position:0%
the customers names and contact
information<00:01:25.640><c> are</c><00:01:26.210><c> stored</c><00:01:26.570><c> in</c><00:01:26.720><c> the</c><00:01:26.840><c> customers</c>

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

00:01:27.290 --> 00:01:29.499 align:start position:0%
information are stored in the customers
table<00:01:27.530><c> and</c><00:01:27.860><c> the</c><00:01:28.490><c> order</c><00:01:28.759><c> ID</c><00:01:28.909><c> numbers</c><00:01:29.360><c> are</c>

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

00:01:29.509 --> 00:01:31.780 align:start position:0%
table and the order ID numbers are
stored<00:01:29.720><c> in</c><00:01:29.960><c> the</c><00:01:30.079><c> orders</c><00:01:30.409><c> table</c><00:01:30.619><c> so</c><00:01:31.460><c> that</c><00:01:31.490><c> means</c>

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

00:01:31.790 --> 00:01:33.280 align:start position:0%
stored in the orders table so that means
we<00:01:31.939><c> need</c><00:01:32.090><c> both</c><00:01:32.329><c> of</c><00:01:32.360><c> these</c><00:01:32.630><c> tables</c><00:01:33.020><c> in</c><00:01:33.200><c> our</c>

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

00:01:33.290 --> 00:01:35.800 align:start position:0%
we need both of these tables in our
query

00:01:35.800 --> 00:01:35.810 align:start position:0%
 
 

00:01:35.810 --> 00:01:38.139 align:start position:0%
 
at<00:01:36.159><c> this</c><00:01:37.159><c> point</c><00:01:37.460><c> we</c><00:01:37.640><c> have</c><00:01:37.759><c> enough</c><00:01:37.970><c> information</c>

00:01:38.139 --> 00:01:38.149 align:start position:0%
at this point we have enough information
 

00:01:38.149 --> 00:01:41.530 align:start position:0%
at this point we have enough information
to<00:01:38.659><c> start</c><00:01:38.869><c> creating</c><00:01:39.350><c> our</c><00:01:39.560><c> query</c><00:01:40.270><c> go</c><00:01:41.270><c> to</c><00:01:41.329><c> the</c>

00:01:41.530 --> 00:01:41.540 align:start position:0%
to start creating our query go to the
 

00:01:41.540 --> 00:01:48.340 align:start position:0%
to start creating our query go to the
create<00:01:41.869><c> tab</c><00:01:41.899><c> and</c><00:01:42.909><c> select</c><00:01:43.909><c> query</c><00:01:44.299><c> design</c><00:01:47.350><c> we're</c>

00:01:48.340 --> 00:01:48.350 align:start position:0%
create tab and select query design we're
 

00:01:48.350 --> 00:01:50.560 align:start position:0%
create tab and select query design we're
going<00:01:48.530><c> to</c><00:01:48.619><c> add</c><00:01:48.770><c> the</c><00:01:49.070><c> customers</c><00:01:49.610><c> table</c><00:01:49.820><c> and</c><00:01:50.149><c> the</c>

00:01:50.560 --> 00:01:50.570 align:start position:0%
going to add the customers table and the
 

00:01:50.570 --> 00:01:57.600 align:start position:0%
going to add the customers table and the
orders<00:01:50.930><c> table</c><00:01:51.399><c> and</c><00:01:54.729><c> then</c><00:01:55.729><c> close</c><00:01:56.030><c> this</c><00:01:56.210><c> window</c>

00:01:57.600 --> 00:01:57.610 align:start position:0%
orders table and then close this window
 

00:01:57.610 --> 00:02:05.529 align:start position:0%
orders table and then close this window
you<00:01:58.610><c> can</c><00:01:58.640><c> resize</c><00:01:59.149><c> these</c><00:01:59.420><c> if</c><00:01:59.630><c> you</c><00:01:59.720><c> need</c><00:01:59.899><c> to</c><00:02:04.539><c> then</c>

00:02:05.529 --> 00:02:05.539 align:start position:0%
you can resize these if you need to then
 

00:02:05.539 --> 00:02:07.029 align:start position:0%
you can resize these if you need to then
we're<00:02:05.750><c> going</c><00:02:05.929><c> to</c><00:02:05.960><c> double</c><00:02:06.409><c> click</c><00:02:06.530><c> on</c><00:02:06.649><c> the</c>

00:02:07.029 --> 00:02:07.039 align:start position:0%
we're going to double click on the
 

00:02:07.039 --> 00:02:09.580 align:start position:0%
we're going to double click on the
fields<00:02:07.340><c> that</c><00:02:07.399><c> we</c><00:02:07.579><c> need</c><00:02:08.170><c> so</c><00:02:09.170><c> we'll</c><00:02:09.289><c> add</c><00:02:09.440><c> the</c>

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

00:02:09.590 --> 00:02:12.270 align:start position:0%
fields that we need so we'll add the
customers<00:02:10.009><c> first</c><00:02:10.310><c> name</c><00:02:10.630><c> last</c><00:02:11.630><c> name</c><00:02:11.840><c> street</c>

00:02:12.270 --> 00:02:12.280 align:start position:0%
customers first name last name street
 

00:02:12.280 --> 00:02:20.080 align:start position:0%
customers first name last name street
address<00:02:14.049><c> city</c><00:02:15.049><c> state</c><00:02:15.940><c> zip</c><00:02:17.350><c> code</c><00:02:18.350><c> and</c><00:02:19.090><c> phone</c>

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

00:02:20.090 --> 00:02:23.170 align:start position:0%
address city state zip code and phone
number<00:02:20.420><c> and</c><00:02:21.160><c> from</c><00:02:22.160><c> the</c><00:02:22.310><c> orders</c><00:02:22.610><c> table</c><00:02:22.790><c> we'll</c>

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

00:02:23.180 --> 00:02:27.009 align:start position:0%
number and from the orders table we'll
need<00:02:23.330><c> the</c><00:02:23.599><c> ID</c><00:02:23.840><c> field</c><00:02:25.510><c> when</c><00:02:26.510><c> you</c><00:02:26.599><c> have</c><00:02:26.750><c> more</c>

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

00:02:27.019 --> 00:02:28.660 align:start position:0%
need the ID field when you have more
than<00:02:27.080><c> one</c><00:02:27.349><c> table</c><00:02:27.560><c> in</c><00:02:27.799><c> a</c><00:02:27.860><c> query</c><00:02:28.099><c> they</c><00:02:28.400><c> will</c><00:02:28.549><c> be</c>

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

00:02:28.670 --> 00:02:31.030 align:start position:0%
than one table in a query they will be
joined<00:02:29.030><c> by</c><00:02:29.090><c> a</c><00:02:29.420><c> line</c><00:02:29.750><c> and</c><00:02:30.019><c> this</c><00:02:30.440><c> is</c><00:02:30.500><c> called</c><00:02:30.830><c> a</c>

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

00:02:31.040 --> 00:02:33.490 align:start position:0%
joined by a line and this is called a
join<00:02:31.370><c> the</c><00:02:32.239><c> join</c><00:02:32.480><c> will</c><00:02:32.660><c> often</c><00:02:33.019><c> have</c><00:02:33.170><c> an</c><00:02:33.319><c> arrow</c>

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

00:02:33.500 --> 00:02:35.020 align:start position:0%
join the join will often have an arrow
that<00:02:33.769><c> points</c><00:02:33.830><c> to</c><00:02:34.280><c> the</c><00:02:34.370><c> left</c><00:02:34.519><c> or</c><00:02:34.880><c> the</c><00:02:34.910><c> right</c>

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

00:02:35.030 --> 00:02:37.240 align:start position:0%
that points to the left or the right
which<00:02:35.810><c> tells</c><00:02:36.110><c> the</c><00:02:36.260><c> query</c><00:02:36.470><c> which</c><00:02:36.739><c> table</c><00:02:37.130><c> to</c>

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

00:02:37.250 --> 00:02:40.090 align:start position:0%
which tells the query which table to
look<00:02:37.280><c> at</c><00:02:37.580><c> first</c><00:02:38.380><c> sometimes</c><00:02:39.380><c> you'll</c><00:02:39.799><c> need</c><00:02:39.980><c> to</c>

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

00:02:40.100 --> 00:02:41.920 align:start position:0%
look at first sometimes you'll need to
change<00:02:40.370><c> the</c><00:02:40.609><c> direction</c><00:02:40.760><c> to</c><00:02:41.269><c> get</c><00:02:41.390><c> the</c><00:02:41.450><c> results</c>

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

00:02:41.930 --> 00:02:42.640 align:start position:0%
change the direction to get the results
that<00:02:41.989><c> you</c><00:02:42.200><c> want</c>

00:02:42.640 --> 00:02:42.650 align:start position:0%
that you want
 

00:02:42.650 --> 00:02:44.920 align:start position:0%
that you want
we're<00:02:43.489><c> going</c><00:02:43.700><c> to</c><00:02:43.850><c> double</c><00:02:44.120><c> click</c><00:02:44.420><c> on</c><00:02:44.600><c> the</c><00:02:44.750><c> join</c>

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

00:02:44.930 --> 00:02:47.860 align:start position:0%
we're going to double click on the join
to<00:02:45.140><c> change</c><00:02:45.410><c> it</c><00:02:45.590><c> and</c><00:02:46.120><c> we</c><00:02:47.120><c> want</c><00:02:47.299><c> to</c><00:02:47.390><c> select</c><00:02:47.630><c> the</c>

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

00:02:47.870 --> 00:02:50.020 align:start position:0%
to change it and we want to select the
third<00:02:48.109><c> option</c><00:02:48.380><c> which</c><00:02:48.709><c> says</c><00:02:49.040><c> include</c><00:02:49.730><c> all</c>

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

00:02:50.030 --> 00:02:52.750 align:start position:0%
third option which says include all
records<00:02:50.540><c> from</c><00:02:50.690><c> the</c><00:02:50.870><c> orders</c><00:02:51.200><c> table</c><00:02:51.380><c> and</c><00:02:51.709><c> in</c><00:02:52.670><c> the</c>

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

00:02:52.760 --> 00:02:54.039 align:start position:0%
records from the orders table and in the
next<00:02:52.940><c> video</c><00:02:53.180><c> we're</c><00:02:53.359><c> going</c><00:02:53.480><c> to</c><00:02:53.569><c> talk</c><00:02:53.720><c> a</c><00:02:53.780><c> little</c>

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

00:02:54.049 --> 00:02:55.420 align:start position:0%
next video we're going to talk a little
more<00:02:54.140><c> about</c><00:02:54.290><c> why</c><00:02:54.769><c> we're</c><00:02:54.980><c> choosing</c><00:02:55.160><c> this</c>

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

00:02:55.430 --> 00:02:57.580 align:start position:0%
more about why we're choosing this
option<00:02:55.609><c> but</c><00:02:56.269><c> basically</c><00:02:56.720><c> this</c><00:02:56.989><c> means</c><00:02:57.230><c> that</c><00:02:57.440><c> it</c>

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

00:02:57.590 --> 00:02:59.170 align:start position:0%
option but basically this means that it
will<00:02:57.709><c> pull</c><00:02:57.890><c> from</c><00:02:58.100><c> the</c><00:02:58.220><c> orders</c><00:02:58.549><c> table</c><00:02:58.730><c> first</c>

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

00:02:59.180 --> 00:03:01.180 align:start position:0%
will pull from the orders table first
which<00:02:59.840><c> ensures</c><00:03:00.200><c> that</c><00:03:00.350><c> only</c><00:03:00.890><c> the</c><00:03:01.010><c> customers</c>

00:03:01.180 --> 00:03:01.190 align:start position:0%
which ensures that only the customers
 

00:03:01.190 --> 00:03:02.890 align:start position:0%
which ensures that only the customers
who<00:03:01.609><c> have</c><00:03:01.760><c> placed</c><00:03:01.970><c> an</c><00:03:02.180><c> order</c><00:03:02.359><c> will</c><00:03:02.750><c> be</c>

00:03:02.890 --> 00:03:02.900 align:start position:0%
who have placed an order will be
 

00:03:02.900 --> 00:03:06.550 align:start position:0%
who have placed an order will be
included<00:03:04.329><c> when</c><00:03:05.329><c> you</c><00:03:05.389><c> click</c><00:03:05.630><c> OK</c><00:03:05.959><c> you</c><00:03:06.019><c> can</c><00:03:06.200><c> see</c>

00:03:06.550 --> 00:03:06.560 align:start position:0%
included when you click OK you can see
 

00:03:06.560 --> 00:03:08.140 align:start position:0%
included when you click OK you can see
that<00:03:06.739><c> the</c><00:03:06.859><c> arrow</c><00:03:07.040><c> now</c><00:03:07.340><c> goes</c><00:03:07.609><c> from</c><00:03:07.910><c> right</c><00:03:08.090><c> to</c>

00:03:08.140 --> 00:03:08.150 align:start position:0%
that the arrow now goes from right to
 

00:03:08.150 --> 00:03:12.430 align:start position:0%
that the arrow now goes from right to
left<00:03:10.060><c> the</c><00:03:11.060><c> fourth</c><00:03:11.329><c> step</c><00:03:11.630><c> is</c><00:03:11.810><c> to</c><00:03:11.900><c> determine</c>

00:03:12.430 --> 00:03:12.440 align:start position:0%
left the fourth step is to determine
 

00:03:12.440 --> 00:03:14.520 align:start position:0%
left the fourth step is to determine
which<00:03:12.769><c> search</c><00:03:13.130><c> criteria</c><00:03:13.760><c> you</c><00:03:13.819><c> need</c><00:03:14.090><c> to</c><00:03:14.269><c> use</c>

00:03:14.520 --> 00:03:14.530 align:start position:0%
which search criteria you need to use
 

00:03:14.530 --> 00:03:16.930 align:start position:0%
which search criteria you need to use
we're<00:03:15.530><c> going</c><00:03:15.560><c> to</c><00:03:15.739><c> be</c><00:03:15.889><c> adding</c><00:03:16.100><c> criteria</c><00:03:16.760><c> under</c>

00:03:16.930 --> 00:03:16.940 align:start position:0%
we're going to be adding criteria under
 

00:03:16.940 --> 00:03:20.770 align:start position:0%
we're going to be adding criteria under
the<00:03:17.150><c> city</c><00:03:17.510><c> and</c><00:03:17.780><c> phone</c><00:03:18.200><c> number</c><00:03:18.530><c> fields</c><00:03:19.780><c> first</c>

00:03:20.770 --> 00:03:20.780 align:start position:0%
the city and phone number fields first
 

00:03:20.780 --> 00:03:22.840 align:start position:0%
the city and phone number fields first
we<00:03:21.079><c> want</c><00:03:21.290><c> to</c><00:03:21.350><c> exclude</c><00:03:21.859><c> all</c><00:03:22.130><c> of</c><00:03:22.310><c> the</c><00:03:22.430><c> customers</c>

00:03:22.840 --> 00:03:22.850 align:start position:0%
we want to exclude all of the customers
 

00:03:22.850 --> 00:03:25.210 align:start position:0%
we want to exclude all of the customers
who<00:03:23.000><c> are</c><00:03:23.030><c> in</c><00:03:23.329><c> Raleigh</c><00:03:23.680><c> to</c><00:03:24.680><c> do</c><00:03:24.829><c> this</c><00:03:25.010><c> we're</c>

00:03:25.210 --> 00:03:25.220 align:start position:0%
who are in Raleigh to do this we're
 

00:03:25.220 --> 00:03:26.770 align:start position:0%
who are in Raleigh to do this we're
going<00:03:25.340><c> to</c><00:03:25.430><c> need</c><00:03:25.549><c> to</c><00:03:25.819><c> use</c><00:03:25.850><c> a</c><00:03:26.030><c> very</c><00:03:26.450><c> specific</c>

00:03:26.770 --> 00:03:26.780 align:start position:0%
going to need to use a very specific
 

00:03:26.780 --> 00:03:30.789 align:start position:0%
going to need to use a very specific
syntax<00:03:27.700><c> so</c><00:03:28.700><c> for</c><00:03:28.940><c> the</c><00:03:29.000><c> city</c><00:03:29.180><c> criteria</c><00:03:29.269><c> type</c><00:03:30.200><c> not</c>

00:03:30.789 --> 00:03:30.799 align:start position:0%
syntax so for the city criteria type not
 

00:03:30.799 --> 00:03:34.150 align:start position:0%
syntax so for the city criteria type not
in<00:03:31.100><c> and</c><00:03:31.690><c> then</c><00:03:32.690><c> in</c><00:03:32.840><c> parentheses</c><00:03:33.380><c> type</c><00:03:33.650><c> Raleigh</c>

00:03:34.150 --> 00:03:34.160 align:start position:0%
in and then in parentheses type Raleigh
 

00:03:34.160 --> 00:03:36.640 align:start position:0%
in and then in parentheses type Raleigh
in<00:03:34.459><c> quotation</c><00:03:35.000><c> marks</c><00:03:35.109><c> and</c><00:03:36.109><c> you</c><00:03:36.230><c> can</c><00:03:36.380><c> use</c><00:03:36.500><c> the</c>

00:03:36.640 --> 00:03:36.650 align:start position:0%
in quotation marks and you can use the
 

00:03:36.650 --> 00:03:38.319 align:start position:0%
in quotation marks and you can use the
syntax<00:03:36.920><c> whenever</c><00:03:37.489><c> you</c><00:03:37.639><c> want</c><00:03:37.850><c> to</c><00:03:37.970><c> exclude</c>

00:03:38.319 --> 00:03:38.329 align:start position:0%
syntax whenever you want to exclude
 

00:03:38.329 --> 00:03:41.530 align:start position:0%
syntax whenever you want to exclude
something<00:03:38.720><c> from</c><00:03:39.019><c> the</c><00:03:39.109><c> query</c><00:03:39.380><c> results</c><00:03:40.480><c> now</c><00:03:41.480><c> we</c>

00:03:41.530 --> 00:03:41.540 align:start position:0%
something from the query results now we
 

00:03:41.540 --> 00:03:43.539 align:start position:0%
something from the query results now we
also<00:03:41.780><c> need</c><00:03:42.200><c> some</c><00:03:42.530><c> way</c><00:03:42.560><c> of</c><00:03:42.739><c> limiting</c><00:03:43.430><c> the</c>

00:03:43.539 --> 00:03:43.549 align:start position:0%
also need some way of limiting the
 

00:03:43.549 --> 00:03:46.030 align:start position:0%
also need some way of limiting the
results<00:03:43.970><c> to</c><00:03:44.120><c> just</c><00:03:44.420><c> the</c><00:03:44.569><c> nearby</c><00:03:44.900><c> towns</c><00:03:45.200><c> and</c><00:03:45.560><c> in</c>

00:03:46.030 --> 00:03:46.040 align:start position:0%
results to just the nearby towns and in
 

00:03:46.040 --> 00:03:47.380 align:start position:0%
results to just the nearby towns and in
this<00:03:46.159><c> case</c><00:03:46.400><c> we're</c><00:03:46.640><c> going</c><00:03:46.760><c> to</c><00:03:46.849><c> do</c><00:03:47.030><c> this</c><00:03:47.180><c> by</c>

00:03:47.380 --> 00:03:47.390 align:start position:0%
this case we're going to do this by
 

00:03:47.390 --> 00:03:49.050 align:start position:0%
this case we're going to do this by
getting<00:03:47.450><c> the</c><00:03:47.840><c> area</c><00:03:48.049><c> code</c><00:03:48.470><c> from</c><00:03:48.799><c> the</c>

00:03:49.050 --> 00:03:49.060 align:start position:0%
getting the area code from the
 

00:03:49.060 --> 00:03:51.420 align:start position:0%
getting the area code from the
phone<00:03:49.180><c> number</c><00:03:49.480><c> field</c><00:03:50.010><c> the</c><00:03:51.010><c> nine</c><00:03:51.190><c> one</c><00:03:51.400><c> nine</c>

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

00:03:51.430 --> 00:03:53.729 align:start position:0%
phone number field the nine one nine
area<00:03:51.910><c> code</c><00:03:52.120><c> covers</c><00:03:52.510><c> Raleigh</c><00:03:52.780><c> and</c><00:03:53.170><c> a</c><00:03:53.380><c> number</c><00:03:53.530><c> of</c>

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

00:03:53.739 --> 00:03:55.860 align:start position:0%
area code covers Raleigh and a number of
nearby<00:03:53.980><c> cities</c><00:03:54.400><c> and</c><00:03:54.550><c> towns</c><00:03:54.730><c> so</c><00:03:55.420><c> this</c><00:03:55.690><c> should</c>

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

00:03:55.870 --> 00:03:58.410 align:start position:0%
nearby cities and towns so this should
give<00:03:56.050><c> us</c><00:03:56.080><c> a</c><00:03:56.260><c> pretty</c><00:03:56.290><c> good</c><00:03:56.590><c> range</c><00:03:57.150><c> will</c><00:03:58.150><c> need</c><00:03:58.330><c> to</c>

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

00:03:58.420 --> 00:04:00.270 align:start position:0%
give us a pretty good range will need to
use<00:03:58.569><c> a</c><00:03:58.599><c> syntax</c><00:03:59.170><c> that</c><00:03:59.410><c> looks</c><00:03:59.620><c> at</c><00:03:59.800><c> the</c><00:03:59.920><c> beginning</c>

00:04:00.270 --> 00:04:00.280 align:start position:0%
use a syntax that looks at the beginning
 

00:04:00.280 --> 00:04:04.559 align:start position:0%
use a syntax that looks at the beginning
of<00:04:00.520><c> each</c><00:04:00.790><c> phone</c><00:04:01.120><c> number</c><00:04:01.480><c> so</c><00:04:02.170><c> type</c><00:04:02.410><c> like</c><00:04:03.010><c> and</c><00:04:03.569><c> in</c>

00:04:04.559 --> 00:04:04.569 align:start position:0%
of each phone number so type like and in
 

00:04:04.569 --> 00:04:07.550 align:start position:0%
of each phone number so type like and in
parentheses<00:04:05.200><c> type</c><00:04:05.620><c> quote</c><00:04:06.220><c> nine</c><00:04:06.670><c> one</c><00:04:06.940><c> nine</c>

00:04:07.550 --> 00:04:07.560 align:start position:0%
parentheses type quote nine one nine
 

00:04:07.560 --> 00:04:10.339 align:start position:0%
parentheses type quote nine one nine
asterisk<00:04:08.560><c> end</c><00:04:08.860><c> quote</c>

00:04:10.339 --> 00:04:10.349 align:start position:0%
asterisk end quote
 

00:04:10.349 --> 00:04:13.170 align:start position:0%
asterisk end quote
the<00:04:11.349><c> asterisk</c><00:04:11.709><c> means</c><00:04:12.069><c> that</c><00:04:12.340><c> any</c><00:04:12.580><c> phone</c><00:04:12.849><c> number</c>

00:04:13.170 --> 00:04:13.180 align:start position:0%
the asterisk means that any phone number
 

00:04:13.180 --> 00:04:15.000 align:start position:0%
the asterisk means that any phone number
can<00:04:13.330><c> come</c><00:04:13.569><c> after</c><00:04:13.750><c> the</c><00:04:14.019><c> nine</c><00:04:14.230><c> one</c><00:04:14.440><c> nine</c><00:04:14.500><c> area</c>

00:04:15.000 --> 00:04:15.010 align:start position:0%
can come after the nine one nine area
 

00:04:15.010 --> 00:04:17.430 align:start position:0%
can come after the nine one nine area
code<00:04:15.250><c> and</c><00:04:15.459><c> there</c><00:04:16.269><c> are</c><00:04:16.389><c> many</c><00:04:16.570><c> other</c><00:04:16.810><c> syntaxes</c>

00:04:17.430 --> 00:04:17.440 align:start position:0%
code and there are many other syntaxes
 

00:04:17.440 --> 00:04:19.229 align:start position:0%
code and there are many other syntaxes
that<00:04:17.590><c> you</c><00:04:17.650><c> can</c><00:04:17.799><c> use</c><00:04:18.010><c> and</c><00:04:18.220><c> in</c><00:04:18.730><c> the</c><00:04:18.820><c> next</c><00:04:19.000><c> video</c>

00:04:19.229 --> 00:04:19.239 align:start position:0%
that you can use and in the next video
 

00:04:19.239 --> 00:04:20.789 align:start position:0%
that you can use and in the next video
we'll<00:04:19.450><c> look</c><00:04:19.510><c> at</c><00:04:19.630><c> a</c><00:04:19.690><c> few</c><00:04:19.959><c> other</c><00:04:20.139><c> examples</c><00:04:20.350><c> of</c>

00:04:20.789 --> 00:04:20.799 align:start position:0%
we'll look at a few other examples of
 

00:04:20.799 --> 00:04:23.460 align:start position:0%
we'll look at a few other examples of
these<00:04:21.330><c> now</c><00:04:22.330><c> in</c><00:04:22.479><c> this</c><00:04:22.600><c> case</c><00:04:22.810><c> we're</c><00:04:23.080><c> putting</c><00:04:23.350><c> the</c>

00:04:23.460 --> 00:04:23.470 align:start position:0%
these now in this case we're putting the
 

00:04:23.470 --> 00:04:26.010 align:start position:0%
these now in this case we're putting the
criteria<00:04:23.979><c> on</c><00:04:24.160><c> the</c><00:04:24.370><c> same</c><00:04:24.610><c> row</c><00:04:24.910><c> because</c><00:04:25.660><c> we</c><00:04:25.810><c> want</c>

00:04:26.010 --> 00:04:26.020 align:start position:0%
criteria on the same row because we want
 

00:04:26.020 --> 00:04:27.450 align:start position:0%
criteria on the same row because we want
the<00:04:26.110><c> customers</c><00:04:26.560><c> to</c><00:04:26.590><c> meet</c><00:04:26.860><c> both</c><00:04:27.160><c> of</c><00:04:27.340><c> these</c>

00:04:27.450 --> 00:04:27.460 align:start position:0%
the customers to meet both of these
 

00:04:27.460 --> 00:04:29.879 align:start position:0%
the customers to meet both of these
criteria<00:04:27.729><c> if</c><00:04:28.180><c> they</c><00:04:28.990><c> just</c><00:04:29.200><c> meet</c><00:04:29.410><c> one</c><00:04:29.650><c> of</c><00:04:29.680><c> the</c>

00:04:29.879 --> 00:04:29.889 align:start position:0%
criteria if they just meet one of the
 

00:04:29.889 --> 00:04:31.320 align:start position:0%
criteria if they just meet one of the
criteria<00:04:29.919><c> then</c><00:04:30.610><c> they're</c><00:04:30.729><c> not</c><00:04:30.880><c> going</c><00:04:31.150><c> to</c><00:04:31.180><c> be</c>

00:04:31.320 --> 00:04:31.330 align:start position:0%
criteria then they're not going to be
 

00:04:31.330 --> 00:04:33.719 align:start position:0%
criteria then they're not going to be
included<00:04:31.810><c> in</c><00:04:31.900><c> the</c><00:04:32.050><c> query</c><00:04:32.260><c> results</c><00:04:32.800><c> if</c><00:04:32.950><c> we</c>

00:04:33.719 --> 00:04:33.729 align:start position:0%
included in the query results if we
 

00:04:33.729 --> 00:04:35.070 align:start position:0%
included in the query results if we
needed<00:04:34.030><c> them</c><00:04:34.150><c> to</c><00:04:34.300><c> meet</c><00:04:34.450><c> one</c><00:04:34.690><c> or</c><00:04:34.720><c> the</c><00:04:34.930><c> other</c>

00:04:35.070 --> 00:04:35.080 align:start position:0%
needed them to meet one or the other
 

00:04:35.080 --> 00:04:36.750 align:start position:0%
needed them to meet one or the other
then<00:04:35.560><c> we</c><00:04:35.710><c> would</c><00:04:35.860><c> put</c><00:04:36.040><c> one</c><00:04:36.280><c> of</c><00:04:36.400><c> these</c><00:04:36.520><c> criteria</c>

00:04:36.750 --> 00:04:36.760 align:start position:0%
then we would put one of these criteria
 

00:04:36.760 --> 00:04:40.950 align:start position:0%
then we would put one of these criteria
on<00:04:37.270><c> the</c><00:04:37.300><c> next</c><00:04:37.720><c> row</c><00:04:39.120><c> this</c><00:04:40.120><c> query</c><00:04:40.389><c> is</c><00:04:40.600><c> finished</c>

00:04:40.950 --> 00:04:40.960 align:start position:0%
on the next row this query is finished
 

00:04:40.960 --> 00:04:43.320 align:start position:0%
on the next row this query is finished
now<00:04:41.139><c> so</c><00:04:41.710><c> we</c><00:04:41.950><c> can</c><00:04:42.130><c> run</c><00:04:42.340><c> it</c><00:04:42.370><c> to</c><00:04:42.610><c> see</c><00:04:42.639><c> the</c><00:04:42.880><c> results</c>

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

00:04:43.330 --> 00:04:46.710 align:start position:0%
now so we can run it to see the results
and<00:04:44.220><c> you</c><00:04:45.220><c> can</c><00:04:45.370><c> see</c><00:04:45.550><c> that</c><00:04:45.729><c> each</c><00:04:45.940><c> customer</c><00:04:46.240><c> meets</c>

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

00:04:46.720 --> 00:04:49.140 align:start position:0%
and you can see that each customer meets
both<00:04:46.990><c> criteria</c><00:04:47.370><c> they</c><00:04:48.370><c> are</c><00:04:48.520><c> not</c><00:04:48.729><c> from</c><00:04:48.910><c> Raleigh</c>

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

00:04:49.150 --> 00:04:51.300 align:start position:0%
both criteria they are not from Raleigh
and<00:04:49.389><c> their</c><00:04:50.050><c> phone</c><00:04:50.229><c> numbers</c><00:04:50.530><c> begin</c><00:04:50.860><c> with</c><00:04:51.040><c> nine</c>

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

00:04:51.310 --> 00:04:54.630 align:start position:0%
and their phone numbers begin with nine
one<00:04:51.520><c> nine</c><00:04:52.500><c> so</c><00:04:53.500><c> generally</c><00:04:53.919><c> more</c><00:04:54.160><c> complex</c>

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

00:04:54.640 --> 00:04:57.060 align:start position:0%
one nine so generally more complex
queries<00:04:55.060><c> require</c><00:04:55.419><c> more</c><00:04:55.750><c> planning</c><00:04:55.950><c> but</c><00:04:56.950><c> you</c>

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

00:04:57.070 --> 00:04:58.350 align:start position:0%
queries require more planning but you
can<00:04:57.190><c> make</c><00:04:57.340><c> it</c><00:04:57.460><c> a</c><00:04:57.520><c> lot</c><00:04:57.760><c> easier</c><00:04:58.090><c> by</c><00:04:58.330><c> just</c>

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

00:04:58.360 --> 00:05:01.080 align:start position:0%
can make it a lot easier by just
following<00:04:59.080><c> the</c><00:04:59.200><c> four</c><00:04:59.470><c> steps</c><00:04:59.800><c> of</c><00:05:00.090><c> pinpointing</c>

00:05:01.080 --> 00:05:01.090 align:start position:0%
following the four steps of pinpointing
 

00:05:01.090 --> 00:05:02.779 align:start position:0%
following the four steps of pinpointing
exactly<00:05:01.660><c> what</c><00:05:01.810><c> you</c><00:05:01.900><c> want</c><00:05:02.050><c> to</c><00:05:02.140><c> find</c><00:05:02.320><c> out</c>

00:05:02.779 --> 00:05:02.789 align:start position:0%
exactly what you want to find out
 

00:05:02.789 --> 00:05:04.830 align:start position:0%
exactly what you want to find out
identifying<00:05:03.789><c> the</c><00:05:04.000><c> information</c><00:05:04.180><c> that</c><00:05:04.750><c> you</c>

00:05:04.830 --> 00:05:04.840 align:start position:0%
identifying the information that you
 

00:05:04.840 --> 00:05:07.469 align:start position:0%
identifying the information that you
need<00:05:05.400><c> locating</c><00:05:06.400><c> the</c><00:05:06.520><c> tables</c><00:05:06.910><c> that</c><00:05:07.090><c> contain</c>

00:05:07.469 --> 00:05:07.479 align:start position:0%
need locating the tables that contain
 

00:05:07.479 --> 00:05:09.900 align:start position:0%
need locating the tables that contain
the<00:05:07.630><c> information</c><00:05:08.140><c> and</c><00:05:08.340><c> determining</c><00:05:09.340><c> exactly</c>

00:05:09.900 --> 00:05:09.910 align:start position:0%
the information and determining exactly
 

00:05:09.910 --> 00:05:12.750 align:start position:0%
the information and determining exactly
what<00:05:10.150><c> criteria</c><00:05:10.690><c> you</c><00:05:10.900><c> need</c><00:05:11.080><c> and</c><00:05:11.430><c> in</c><00:05:12.430><c> the</c><00:05:12.520><c> next</c>

00:05:12.750 --> 00:05:12.760 align:start position:0%
what criteria you need and in the next
 

00:05:12.760 --> 00:05:14.430 align:start position:0%
what criteria you need and in the next
video<00:05:13.030><c> we're</c><00:05:13.240><c> going</c><00:05:13.390><c> to</c><00:05:13.479><c> look</c><00:05:13.660><c> at</c><00:05:13.810><c> joins</c><00:05:14.200><c> and</c>

00:05:14.430 --> 00:05:14.440 align:start position:0%
video we're going to look at joins and
 

00:05:14.440 --> 00:05:16.320 align:start position:0%
video we're going to look at joins and
search<00:05:14.950><c> criteria</c><00:05:15.550><c> and</c><00:05:15.610><c> a</c><00:05:15.850><c> little</c><00:05:16.060><c> bit</c><00:05:16.210><c> more</c>

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

00:05:16.330 --> 00:05:18.550 align:start position:0%
search criteria and a little bit more
detail

00:05:18.550 --> 00:05:18.560 align:start position:0%
detail
 

00:05:18.560 --> 00:05:20.620 align:start position:0%
detail
you