WEBVTT
Kind: captions
Language: en

00:00:00.410 --> 00:00:02.990 align:start position:0%
 
Goodwill<00:00:01.410><c> Community</c><00:00:01.890><c> Foundation</c><00:00:02.520><c> creating</c>

00:00:02.990 --> 00:00:03.000 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.000 --> 00:00:11.049 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.570><c> for</c><00:00:03.810><c> a</c><00:00:03.870><c> better</c><00:00:03.899><c> life</c>

00:00:11.049 --> 00:00:11.059 align:start position:0%
 
 

00:00:11.059 --> 00:00:12.970 align:start position:0%
 
we've<00:00:11.719><c> already</c><00:00:11.900><c> talked</c><00:00:12.260><c> about</c><00:00:12.349><c> how</c><00:00:12.679><c> to</c><00:00:12.740><c> create</c>

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

00:00:12.980 --> 00:00:15.250 align:start position:0%
we've already talked about how to create
a<00:00:13.160><c> simple</c><00:00:13.519><c> query</c><00:00:13.790><c> that</c><00:00:14.030><c> only</c><00:00:14.090><c> uses</c><00:00:14.510><c> one</c><00:00:14.900><c> table</c>

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

00:00:15.260 --> 00:00:17.140 align:start position:0%
a simple query that only uses one table
but<00:00:15.769><c> queries</c><00:00:16.219><c> that</c><00:00:16.340><c> involve</c><00:00:16.610><c> more</c><00:00:16.910><c> than</c><00:00:16.970><c> one</c>

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

00:00:17.150 --> 00:00:19.240 align:start position:0%
but queries that involve more than one
table<00:00:17.599><c> let</c><00:00:17.779><c> you</c><00:00:17.869><c> ask</c><00:00:18.050><c> much</c><00:00:18.470><c> more</c><00:00:18.500><c> interesting</c>

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

00:00:19.250 --> 00:00:21.550 align:start position:0%
table let you ask much more interesting
questions<00:00:19.700><c> to</c><00:00:19.849><c> your</c><00:00:19.970><c> database</c><00:00:20.240><c> now</c><00:00:21.230><c> this</c><00:00:21.380><c> also</c>

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

00:00:21.560 --> 00:00:23.200 align:start position:0%
questions to your database now this also
takes<00:00:21.919><c> a</c><00:00:22.040><c> little</c><00:00:22.189><c> bit</c><00:00:22.340><c> more</c><00:00:22.400><c> planning</c><00:00:22.789><c> than</c><00:00:23.180><c> a</c>

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

00:00:23.210 --> 00:00:25.210 align:start position:0%
takes a little bit more planning than a
single<00:00:23.539><c> table</c><00:00:23.810><c> query</c><00:00:23.990><c> and</c><00:00:24.289><c> there</c><00:00:24.890><c> are</c><00:00:24.980><c> four</c>

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

00:00:25.220 --> 00:00:26.650 align:start position:0%
single table query and there are four
steps<00:00:25.550><c> that</c><00:00:25.669><c> you</c><00:00:25.789><c> can</c><00:00:25.970><c> use</c><00:00:26.180><c> to</c><00:00:26.360><c> help</c><00:00:26.450><c> you</c>

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

00:00:26.660 --> 00:00:30.339 align:start position:0%
steps that you can use to help you
design<00:00:26.960><c> it</c><00:00:27.790><c> the</c><00:00:28.790><c> first</c><00:00:29.059><c> step</c><00:00:29.360><c> is</c><00:00:29.570><c> pinpoint</c>

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

00:00:30.349 --> 00:00:32.200 align:start position:0%
design it the first step is pinpoint
exactly<00:00:30.500><c> what</c><00:00:31.219><c> you</c><00:00:31.340><c> want</c><00:00:31.489><c> to</c><00:00:31.550><c> find</c><00:00:31.730><c> out</c><00:00:32.000><c> in</c>

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

00:00:32.210 --> 00:00:33.970 align:start position:0%
exactly what you want to find out in
other<00:00:32.719><c> words</c><00:00:32.930><c> which</c><00:00:33.290><c> question</c><00:00:33.770><c> are</c><00:00:33.920><c> you</c>

00:00:33.970 --> 00:00:33.980 align:start position:0%
other words which question are you
 

00:00:33.980 --> 00:00:36.459 align:start position:0%
other words which question are you
trying<00:00:34.250><c> to</c><00:00:34.309><c> answer</c><00:00:34.520><c> in</c><00:00:34.940><c> this</c><00:00:35.809><c> example</c><00:00:36.140><c> let's</c>

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

00:00:36.469 --> 00:00:38.470 align:start position:0%
trying to answer in this example let's
say<00:00:36.649><c> our</c><00:00:36.770><c> bakery</c><00:00:37.160><c> is</c><00:00:37.340><c> sending</c><00:00:37.670><c> out</c><00:00:37.760><c> coupons</c><00:00:38.180><c> to</c>

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

00:00:38.480 --> 00:00:40.209 align:start position:0%
say our bakery is sending out coupons to
our<00:00:38.600><c> customers</c><00:00:39.050><c> who</c><00:00:39.200><c> live</c><00:00:39.379><c> outside</c><00:00:39.649><c> the</c><00:00:40.070><c> city</c>

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

00:00:40.219 --> 00:00:42.190 align:start position:0%
our customers who live outside the city
limits<00:00:40.340><c> to</c><00:00:41.059><c> entice</c><00:00:41.329><c> them</c><00:00:41.570><c> to</c><00:00:41.600><c> come</c><00:00:41.870><c> back</c><00:00:42.020><c> to</c>

00:00:42.190 --> 00:00:42.200 align:start position:0%
limits to entice them to come back to
 

00:00:42.200 --> 00:00:44.650 align:start position:0%
limits to entice them to come back to
our<00:00:42.230><c> bakery</c><00:00:43.059><c> obviously</c><00:00:44.059><c> we</c><00:00:44.210><c> don't</c><00:00:44.390><c> want</c><00:00:44.570><c> to</c>

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

00:00:44.660 --> 00:00:46.209 align:start position:0%
our bakery obviously we don't want to
send<00:00:44.839><c> them</c><00:00:44.960><c> to</c><00:00:44.989><c> people</c><00:00:45.379><c> who</c><00:00:45.499><c> live</c><00:00:45.679><c> really</c><00:00:46.010><c> far</c>

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

00:00:46.219 --> 00:00:48.430 align:start position:0%
send them to people who live really far
away<00:00:46.309><c> we</c><00:00:47.089><c> just</c><00:00:47.120><c> want</c><00:00:47.480><c> to</c><00:00:47.539><c> focus</c><00:00:47.690><c> on</c><00:00:47.989><c> people</c><00:00:48.199><c> who</c>

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

00:00:48.440 --> 00:00:50.139 align:start position:0%
away we just want to focus on people who
live<00:00:48.589><c> relatively</c><00:00:49.159><c> close</c><00:00:49.339><c> to</c><00:00:49.699><c> Raleigh</c><00:00:49.909><c> and</c>

00:00:50.139 --> 00:00:50.149 align:start position:0%
live relatively close to Raleigh and
 

00:00:50.149 --> 00:00:52.180 align:start position:0%
live relatively close to Raleigh and
we're<00:00:51.019><c> also</c><00:00:51.109><c> just</c><00:00:51.350><c> going</c><00:00:51.620><c> to</c><00:00:51.710><c> send</c><00:00:51.920><c> them</c><00:00:52.070><c> to</c>

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

00:00:52.190 --> 00:00:53.709 align:start position:0%
we're also just going to send them to
customers<00:00:52.579><c> who</c><00:00:52.760><c> have</c><00:00:52.879><c> previously</c><00:00:53.480><c> placed</c>

00:00:53.709 --> 00:00:53.719 align:start position:0%
customers who have previously placed
 

00:00:53.719 --> 00:00:56.319 align:start position:0%
customers who have previously placed
orders<00:00:54.170><c> at</c><00:00:54.350><c> our</c><00:00:54.469><c> bakery</c><00:00:54.730><c> the</c><00:00:55.730><c> customers</c><00:00:56.210><c> who</c>

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

00:00:56.329 --> 00:00:57.610 align:start position:0%
orders at our bakery the customers who
meet<00:00:56.480><c> all</c><00:00:56.690><c> three</c><00:00:56.989><c> of</c><00:00:57.109><c> these</c><00:00:57.260><c> requirements</c>

00:00:57.610 --> 00:00:57.620 align:start position:0%
meet all three of these requirements
 

00:00:57.620 --> 00:01:00.430 align:start position:0%
meet all three of these requirements
will<00:00:57.949><c> receive</c><00:00:58.339><c> coupons</c><00:00:58.960><c> so</c><00:00:59.960><c> the</c><00:01:00.079><c> question</c>

00:01:00.430 --> 00:01:00.440 align:start position:0%
will receive coupons so the question
 

00:01:00.440 --> 00:01:02.229 align:start position:0%
will receive coupons so the question
that<00:01:00.559><c> we're</c><00:01:00.710><c> trying</c><00:01:00.739><c> to</c><00:01:01.010><c> answer</c><00:01:01.159><c> is</c><00:01:01.399><c> which</c>

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

00:01:02.239 --> 00:01:04.780 align:start position:0%
that we're trying to answer is which
customers<00:01:02.839><c> live</c><00:01:03.109><c> in</c><00:01:03.319><c> our</c><00:01:03.499><c> area</c><00:01:03.530><c> are</c><00:01:04.010><c> outside</c>

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

00:01:04.790 --> 00:01:06.910 align:start position:0%
customers live in our area are outside
the<00:01:04.940><c> city</c><00:01:05.089><c> limits</c><00:01:05.210><c> and</c><00:01:05.720><c> have</c><00:01:06.409><c> placed</c><00:01:06.680><c> an</c><00:01:06.830><c> order</c>

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

00:01:06.920 --> 00:01:10.270 align:start position:0%
the city limits and have placed an order
at<00:01:07.190><c> our</c><00:01:07.220><c> bakery</c><00:01:08.140><c> the</c><00:01:09.140><c> second</c><00:01:09.530><c> step</c><00:01:09.740><c> is</c><00:01:09.979><c> to</c>

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

00:01:10.280 --> 00:01:12.100 align:start position:0%
at our bakery the second step is to
identify<00:01:10.460><c> the</c><00:01:10.880><c> information</c><00:01:11.150><c> that</c><00:01:11.750><c> we</c><00:01:11.870><c> need</c>

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

00:01:12.110 --> 00:01:14.560 align:start position:0%
identify the information that we need
we'll<00:01:12.860><c> need</c><00:01:13.040><c> the</c><00:01:13.190><c> customers</c><00:01:13.610><c> names</c><00:01:13.940><c> and</c><00:01:14.240><c> their</c>

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

00:01:14.570 --> 00:01:16.990 align:start position:0%
we'll need the customers names and their
contact<00:01:14.990><c> information</c><00:01:15.290><c> and</c><00:01:15.740><c> in</c><00:01:16.549><c> order</c><00:01:16.759><c> to</c><00:01:16.880><c> know</c>

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

00:01:17.000 --> 00:01:18.399 align:start position:0%
contact information and in order to know
whether<00:01:17.240><c> they've</c><00:01:17.479><c> placed</c><00:01:17.780><c> an</c><00:01:17.960><c> order</c><00:01:18.079><c> at</c><00:01:18.380><c> our</c>

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

00:01:18.409 --> 00:01:20.170 align:start position:0%
whether they've placed an order at our
bakery<00:01:18.530><c> we'll</c><00:01:19.189><c> also</c><00:01:19.340><c> need</c><00:01:19.579><c> to</c><00:01:19.729><c> look</c><00:01:19.850><c> at</c><00:01:20.060><c> the</c>

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

00:01:20.180 --> 00:01:23.530 align:start position:0%
bakery we'll also need to look at the
order<00:01:20.360><c> ID</c><00:01:20.659><c> numbers</c><00:01:21.670><c> the</c><00:01:22.670><c> third</c><00:01:22.909><c> step</c><00:01:23.240><c> is</c><00:01:23.479><c> to</c>

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

00:01:23.540 --> 00:01:25.630 align:start position:0%
order ID numbers the third step is to
locate<00:01:24.079><c> the</c><00:01:24.469><c> tables</c><00:01:24.680><c> that</c><00:01:24.979><c> contain</c><00:01:25.460><c> the</c>

00:01:25.630 --> 00:01:25.640 align:start position:0%
locate the tables that contain the
 

00:01:25.640 --> 00:01:28.060 align:start position:0%
locate the tables that contain the
information<00:01:26.180><c> that</c><00:01:26.360><c> we</c><00:01:26.479><c> need</c><00:01:26.689><c> in</c><00:01:26.930><c> this</c><00:01:27.860><c> case</c>

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

00:01:28.070 --> 00:01:29.560 align:start position:0%
information that we need in this case
the<00:01:28.280><c> customers</c><00:01:28.700><c> names</c><00:01:29.030><c> and</c><00:01:29.360><c> contact</c>

00:01:29.560 --> 00:01:29.570 align:start position:0%
the customers names and contact
 

00:01:29.570 --> 00:01:31.600 align:start position:0%
the customers names and contact
information<00:01:29.930><c> are</c><00:01:30.530><c> stored</c><00:01:30.860><c> in</c><00:01:31.039><c> the</c><00:01:31.130><c> customers</c>

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

00:01:31.610 --> 00:01:33.789 align:start position:0%
information are stored in the customers
table<00:01:31.820><c> and</c><00:01:32.149><c> the</c><00:01:32.780><c> order</c><00:01:33.079><c> ID</c><00:01:33.229><c> numbers</c><00:01:33.649><c> are</c>

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

00:01:33.799 --> 00:01:36.100 align:start position:0%
table and the order ID numbers are
stored<00:01:34.100><c> in</c><00:01:34.250><c> the</c><00:01:34.399><c> orders</c><00:01:34.729><c> table</c><00:01:34.909><c> so</c><00:01:35.750><c> that</c><00:01:35.899><c> means</c>

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

00:01:36.110 --> 00:01:37.600 align:start position:0%
stored in the orders table so that means
we<00:01:36.259><c> need</c><00:01:36.289><c> both</c><00:01:36.649><c> of</c><00:01:36.680><c> these</c><00:01:36.920><c> tables</c><00:01:37.340><c> in</c><00:01:37.520><c> our</c>

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

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

00:01:39.340 --> 00:01:39.350 align:start position:0%
query
 

00:01:39.350 --> 00:01:42.550 align:start position:0%
query
at<00:01:40.479><c> this</c><00:01:41.479><c> point</c><00:01:41.720><c> we</c><00:01:41.930><c> have</c><00:01:42.080><c> enough</c><00:01:42.290><c> information</c>

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

00:01:42.560 --> 00:01:45.850 align:start position:0%
at this point we have enough information
to<00:01:42.860><c> start</c><00:01:43.189><c> creating</c><00:01:43.670><c> our</c><00:01:43.850><c> query</c><00:01:44.560><c> go</c><00:01:45.560><c> to</c><00:01:45.619><c> the</c>

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

00:01:45.860 --> 00:01:51.580 align:start position:0%
to start creating our query go to the
create<00:01:46.070><c> tab</c><00:01:46.430><c> and</c><00:01:47.200><c> select</c><00:01:48.200><c> query</c><00:01:48.619><c> design</c><00:01:50.590><c> we're</c>

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

00:01:51.590 --> 00:01:53.800 align:start position:0%
create tab and select query design we're
going<00:01:51.770><c> to</c><00:01:51.860><c> add</c><00:01:52.009><c> the</c><00:01:52.310><c> customers</c><00:01:52.850><c> table</c><00:01:53.060><c> and</c><00:01:53.360><c> the</c>

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

00:01:53.810 --> 00:02:01.830 align:start position:0%
going to add the customers table and the
orders<00:01:54.170><c> table</c><00:01:54.490><c> and</c><00:01:57.880><c> then</c><00:01:58.880><c> close</c><00:01:59.149><c> this</c><00:01:59.330><c> window</c>

00:02:01.830 --> 00:02:01.840 align:start position:0%
 
 

00:02:01.840 --> 00:02:09.520 align:start position:0%
 
you<00:02:02.840><c> can</c><00:02:02.990><c> resize</c><00:02:03.380><c> these</c><00:02:03.680><c> if</c><00:02:03.860><c> you</c><00:02:03.950><c> need</c><00:02:04.130><c> to</c><00:02:08.530><c> then</c>

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

00:02:09.530 --> 00:02:10.990 align:start position:0%
you can resize these if you need to then
we're<00:02:09.709><c> going</c><00:02:09.920><c> to</c><00:02:09.950><c> double</c><00:02:10.220><c> click</c><00:02:10.520><c> on</c><00:02:10.759><c> the</c>

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

00:02:11.000 --> 00:02:13.540 align:start position:0%
we're going to double click on the
fields<00:02:11.300><c> that</c><00:02:11.360><c> we</c><00:02:11.480><c> need</c><00:02:12.130><c> so</c><00:02:13.130><c> we'll</c><00:02:13.250><c> add</c><00:02:13.400><c> the</c>

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

00:02:13.550 --> 00:02:16.229 align:start position:0%
fields that we need so we'll add the
customers<00:02:14.000><c> first</c><00:02:14.209><c> name</c><00:02:14.590><c> last</c><00:02:15.590><c> name</c><00:02:15.800><c> street</c>

00:02:16.229 --> 00:02:16.239 align:start position:0%
customers first name last name street
 

00:02:16.239 --> 00:02:24.040 align:start position:0%
customers first name last name street
address<00:02:18.040><c> city</c><00:02:19.040><c> state</c><00:02:19.900><c> zip</c><00:02:21.550><c> code</c><00:02:22.550><c> and</c><00:02:23.050><c> phone</c>

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

00:02:24.050 --> 00:02:27.130 align:start position:0%
address city state zip code and phone
number<00:02:24.380><c> and</c><00:02:25.180><c> from</c><00:02:26.180><c> the</c><00:02:26.269><c> orders</c><00:02:26.600><c> table</c><00:02:26.780><c> we'll</c>

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

00:02:27.140 --> 00:02:30.970 align:start position:0%
number and from the orders table we'll
need<00:02:27.319><c> the</c><00:02:27.560><c> ID</c><00:02:27.830><c> field</c><00:02:29.470><c> when</c><00:02:30.470><c> you</c><00:02:30.560><c> have</c><00:02:30.739><c> more</c>

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

00:02:30.980 --> 00:02:32.620 align:start position:0%
need the ID field when you have more
than<00:02:31.040><c> one</c><00:02:31.310><c> table</c><00:02:31.519><c> in</c><00:02:31.760><c> a</c><00:02:31.850><c> query</c><00:02:32.060><c> they</c><00:02:32.360><c> will</c><00:02:32.510><c> be</c>

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

00:02:32.630 --> 00:02:34.990 align:start position:0%
than one table in a query they will be
joined<00:02:32.989><c> by</c><00:02:33.049><c> a</c><00:02:33.410><c> line</c><00:02:33.709><c> and</c><00:02:34.010><c> this</c><00:02:34.400><c> is</c><00:02:34.459><c> called</c><00:02:34.819><c> a</c>

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

00:02:35.000 --> 00:02:37.479 align:start position:0%
joined by a line and this is called a
join<00:02:35.360><c> the</c><00:02:36.200><c> join</c><00:02:36.440><c> will</c><00:02:36.620><c> often</c><00:02:36.980><c> have</c><00:02:37.130><c> an</c><00:02:37.280><c> arrow</c>

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

00:02:37.489 --> 00:02:38.979 align:start position:0%
join the join will often have an arrow
that<00:02:37.730><c> points</c><00:02:37.790><c> to</c><00:02:38.239><c> the</c><00:02:38.330><c> left</c><00:02:38.569><c> or</c><00:02:38.840><c> the</c><00:02:38.870><c> right</c>

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

00:02:38.989 --> 00:02:41.229 align:start position:0%
that points to the left or the right
which<00:02:39.799><c> tells</c><00:02:40.069><c> the</c><00:02:40.220><c> query</c><00:02:40.459><c> which</c><00:02:40.700><c> table</c><00:02:41.090><c> to</c>

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

00:02:41.239 --> 00:02:44.050 align:start position:0%
which tells the query which table to
look<00:02:41.269><c> at</c><00:02:41.540><c> first</c><00:02:42.340><c> sometimes</c><00:02:43.340><c> you'll</c><00:02:43.760><c> need</c><00:02:43.970><c> to</c>

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

00:02:44.060 --> 00:02:45.880 align:start position:0%
look at first sometimes you'll need to
change<00:02:44.329><c> the</c><00:02:44.570><c> direction</c><00:02:44.750><c> to</c><00:02:45.230><c> get</c><00:02:45.350><c> the</c><00:02:45.410><c> results</c>

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

00:02:45.890 --> 00:02:46.630 align:start position:0%
change the direction to get the results
that<00:02:45.950><c> you</c><00:02:46.160><c> want</c>

00:02:46.630 --> 00:02:46.640 align:start position:0%
that you want
 

00:02:46.640 --> 00:02:48.880 align:start position:0%
that you want
we're<00:02:47.450><c> going</c><00:02:47.660><c> to</c><00:02:47.810><c> double</c><00:02:48.230><c> click</c><00:02:48.380><c> on</c><00:02:48.590><c> the</c><00:02:48.709><c> join</c>

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

00:02:48.890 --> 00:02:51.819 align:start position:0%
we're going to double click on the join
to<00:02:49.100><c> change</c><00:02:49.370><c> it</c><00:02:49.549><c> and</c><00:02:50.079><c> we</c><00:02:51.079><c> want</c><00:02:51.260><c> to</c><00:02:51.350><c> select</c><00:02:51.500><c> the</c>

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

00:02:51.829 --> 00:02:54.009 align:start position:0%
to change it and we want to select the
third<00:02:52.070><c> option</c><00:02:52.340><c> which</c><00:02:52.670><c> says</c><00:02:53.000><c> include</c><00:02:53.690><c> all</c>

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

00:02:54.019 --> 00:02:56.740 align:start position:0%
third option which says include all
records<00:02:54.500><c> from</c><00:02:54.680><c> the</c><00:02:54.859><c> orders</c><00:02:55.160><c> table</c><00:02:55.340><c> and</c><00:02:55.670><c> in</c><00:02:56.660><c> the</c>

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

00:02:56.750 --> 00:02:57.940 align:start position:0%
records from the orders table and in the
next<00:02:56.900><c> video</c><00:02:57.049><c> we're</c><00:02:57.320><c> going</c><00:02:57.440><c> to</c><00:02:57.530><c> talk</c><00:02:57.680><c> a</c><00:02:57.739><c> little</c>

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

00:02:57.950 --> 00:02:59.380 align:start position:0%
next video we're going to talk a little
more<00:02:58.100><c> about</c><00:02:58.430><c> why</c><00:02:58.730><c> we're</c><00:02:58.970><c> choosing</c><00:02:59.150><c> this</c>

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

00:02:59.390 --> 00:03:01.539 align:start position:0%
more about why we're choosing this
option<00:02:59.570><c> but</c><00:03:00.290><c> basically</c><00:03:00.709><c> this</c><00:03:00.950><c> means</c><00:03:01.190><c> that</c><00:03:01.400><c> it</c>

00:03:01.539 --> 00:03:01.549 align:start position:0%
option but basically this means that it
 

00:03:01.549 --> 00:03:03.190 align:start position:0%
option but basically this means that it
will<00:03:01.670><c> pull</c><00:03:01.850><c> from</c><00:03:02.090><c> the</c><00:03:02.180><c> orders</c><00:03:02.540><c> table</c><00:03:02.690><c> first</c>

00:03:03.190 --> 00:03:03.200 align:start position:0%
will pull from the orders table first
 

00:03:03.200 --> 00:03:05.170 align:start position:0%
will pull from the orders table first
which<00:03:03.799><c> ensures</c><00:03:04.190><c> that</c><00:03:04.310><c> only</c><00:03:04.850><c> the</c><00:03:04.970><c> customers</c>

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

00:03:05.180 --> 00:03:06.849 align:start position:0%
which ensures that only the customers
who<00:03:05.600><c> have</c><00:03:05.720><c> placed</c><00:03:05.870><c> an</c><00:03:06.170><c> order</c><00:03:06.320><c> will</c><00:03:06.739><c> be</c>

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

00:03:06.859 --> 00:03:08.660 align:start position:0%
who have placed an order will be
included

00:03:08.660 --> 00:03:08.670 align:start position:0%
included
 

00:03:08.670 --> 00:03:10.820 align:start position:0%
included
when<00:03:09.330><c> you</c><00:03:09.420><c> click</c><00:03:09.569><c> OK</c><00:03:09.630><c> you</c><00:03:09.990><c> can</c><00:03:10.170><c> see</c><00:03:10.530><c> that</c><00:03:10.710><c> the</c>

00:03:10.820 --> 00:03:10.830 align:start position:0%
when you click OK you can see that the
 

00:03:10.830 --> 00:03:15.290 align:start position:0%
when you click OK you can see that the
arrow<00:03:11.010><c> now</c><00:03:11.280><c> goes</c><00:03:11.580><c> from</c><00:03:11.850><c> right</c><00:03:12.060><c> to</c><00:03:12.120><c> left</c><00:03:14.300><c> the</c>

00:03:15.290 --> 00:03:15.300 align:start position:0%
arrow now goes from right to left the
 

00:03:15.300 --> 00:03:17.360 align:start position:0%
arrow now goes from right to left the
fourth<00:03:15.569><c> step</c><00:03:15.870><c> is</c><00:03:16.050><c> to</c><00:03:16.140><c> determine</c><00:03:16.680><c> which</c><00:03:17.010><c> search</c>

00:03:17.360 --> 00:03:17.370 align:start position:0%
fourth step is to determine which search
 

00:03:17.370 --> 00:03:20.000 align:start position:0%
fourth step is to determine which search
criteria<00:03:17.970><c> you</c><00:03:18.180><c> need</c><00:03:18.330><c> to</c><00:03:18.510><c> use</c><00:03:18.770><c> we're</c><00:03:19.770><c> going</c><00:03:19.950><c> to</c>

00:03:20.000 --> 00:03:20.010 align:start position:0%
criteria you need to use we're going to
 

00:03:20.010 --> 00:03:22.010 align:start position:0%
criteria you need to use we're going to
be<00:03:20.100><c> adding</c><00:03:20.340><c> criteria</c><00:03:21.000><c> under</c><00:03:21.180><c> the</c><00:03:21.390><c> city</c><00:03:21.750><c> and</c>

00:03:22.010 --> 00:03:22.020 align:start position:0%
be adding criteria under the city and
 

00:03:22.020 --> 00:03:26.480 align:start position:0%
be adding criteria under the city and
phone<00:03:22.440><c> number</c><00:03:22.770><c> fields</c><00:03:24.920><c> first</c><00:03:25.920><c> we</c><00:03:26.220><c> want</c><00:03:26.430><c> to</c>

00:03:26.480 --> 00:03:26.490 align:start position:0%
phone number fields first we want to
 

00:03:26.490 --> 00:03:28.460 align:start position:0%
phone number fields first we want to
exclude<00:03:27.000><c> all</c><00:03:27.270><c> of</c><00:03:27.450><c> the</c><00:03:27.570><c> customers</c><00:03:27.990><c> who</c><00:03:28.140><c> are</c><00:03:28.170><c> in</c>

00:03:28.460 --> 00:03:28.470 align:start position:0%
exclude all of the customers who are in
 

00:03:28.470 --> 00:03:30.800 align:start position:0%
exclude all of the customers who are in
Raleigh<00:03:28.820><c> to</c><00:03:29.820><c> do</c><00:03:29.970><c> this</c><00:03:30.120><c> we're</c><00:03:30.360><c> going</c><00:03:30.480><c> to</c><00:03:30.660><c> need</c>

00:03:30.800 --> 00:03:30.810 align:start position:0%
Raleigh to do this we're going to need
 

00:03:30.810 --> 00:03:34.130 align:start position:0%
Raleigh to do this we're going to need
to<00:03:30.959><c> use</c><00:03:30.990><c> a</c><00:03:31.170><c> very</c><00:03:31.590><c> specific</c><00:03:31.890><c> syntax</c><00:03:32.840><c> so</c><00:03:33.840><c> for</c><00:03:34.080><c> the</c>

00:03:34.130 --> 00:03:34.140 align:start position:0%
to use a very specific syntax so for the
 

00:03:34.140 --> 00:03:37.970 align:start position:0%
to use a very specific syntax so for the
city<00:03:34.320><c> criteria</c><00:03:34.410><c> type</c><00:03:35.340><c> not</c><00:03:35.940><c> in</c><00:03:36.239><c> and</c><00:03:36.830><c> then</c><00:03:37.830><c> in</c>

00:03:37.970 --> 00:03:37.980 align:start position:0%
city criteria type not in and then in
 

00:03:37.980 --> 00:03:40.130 align:start position:0%
city criteria type not in and then in
parentheses<00:03:38.520><c> type</c><00:03:38.790><c> Raleigh</c><00:03:39.300><c> in</c><00:03:39.600><c> quotation</c>

00:03:40.130 --> 00:03:40.140 align:start position:0%
parentheses type Raleigh in quotation
 

00:03:40.140 --> 00:03:42.229 align:start position:0%
parentheses type Raleigh in quotation
marks<00:03:40.410><c> and</c><00:03:40.709><c> you</c><00:03:41.370><c> can</c><00:03:41.520><c> use</c><00:03:41.640><c> the</c><00:03:41.790><c> syntax</c>

00:03:42.229 --> 00:03:42.239 align:start position:0%
marks and you can use the syntax
 

00:03:42.239 --> 00:03:43.970 align:start position:0%
marks and you can use the syntax
whenever<00:03:42.600><c> you</c><00:03:42.750><c> want</c><00:03:42.959><c> to</c><00:03:43.080><c> exclude</c><00:03:43.470><c> something</c>

00:03:43.970 --> 00:03:43.980 align:start position:0%
whenever you want to exclude something
 

00:03:43.980 --> 00:03:47.330 align:start position:0%
whenever you want to exclude something
from<00:03:44.160><c> the</c><00:03:44.250><c> query</c><00:03:44.520><c> results</c><00:03:45.620><c> now</c><00:03:46.620><c> we</c><00:03:46.680><c> also</c><00:03:46.920><c> need</c>

00:03:47.330 --> 00:03:47.340 align:start position:0%
from the query results now we also need
 

00:03:47.340 --> 00:03:49.550 align:start position:0%
from the query results now we also need
some<00:03:47.670><c> way</c><00:03:47.700><c> of</c><00:03:48.120><c> limiting</c><00:03:48.360><c> the</c><00:03:48.690><c> results</c><00:03:49.110><c> to</c><00:03:49.260><c> just</c>

00:03:49.550 --> 00:03:49.560 align:start position:0%
some way of limiting the results to just
 

00:03:49.560 --> 00:03:51.770 align:start position:0%
some way of limiting the results to just
the<00:03:49.709><c> nearby</c><00:03:50.040><c> towns</c><00:03:50.340><c> and</c><00:03:50.700><c> in</c><00:03:51.180><c> this</c><00:03:51.330><c> case</c><00:03:51.540><c> we're</c>

00:03:51.770 --> 00:03:51.780 align:start position:0%
the nearby towns and in this case we're
 

00:03:51.780 --> 00:03:53.360 align:start position:0%
the nearby towns and in this case we're
going<00:03:51.900><c> to</c><00:03:51.989><c> do</c><00:03:52.170><c> this</c><00:03:52.320><c> by</c><00:03:52.500><c> getting</c><00:03:52.560><c> the</c><00:03:52.980><c> area</c>

00:03:53.360 --> 00:03:53.370 align:start position:0%
going to do this by getting the area
 

00:03:53.370 --> 00:03:56.120 align:start position:0%
going to do this by getting the area
code<00:03:53.610><c> from</c><00:03:53.940><c> the</c><00:03:54.150><c> phone</c><00:03:54.330><c> number</c><00:03:54.630><c> field</c><00:03:55.130><c> the</c>

00:03:56.120 --> 00:03:56.130 align:start position:0%
code from the phone number field the
 

00:03:56.130 --> 00:03:57.920 align:start position:0%
code from the phone number field the
nine<00:03:56.310><c> one</c><00:03:56.489><c> nine</c><00:03:56.550><c> area</c><00:03:57.060><c> code</c><00:03:57.269><c> covers</c><00:03:57.660><c> Raleigh</c>

00:03:57.920 --> 00:03:57.930 align:start position:0%
nine one nine area code covers Raleigh
 

00:03:57.930 --> 00:03:59.870 align:start position:0%
nine one nine area code covers Raleigh
and<00:03:58.260><c> a</c><00:03:58.500><c> number</c><00:03:58.769><c> of</c><00:03:58.890><c> nearby</c><00:03:59.190><c> cities</c><00:03:59.519><c> and</c><00:03:59.700><c> towns</c>

00:03:59.870 --> 00:03:59.880 align:start position:0%
and a number of nearby cities and towns
 

00:03:59.880 --> 00:04:01.729 align:start position:0%
and a number of nearby cities and towns
so<00:04:00.540><c> this</c><00:04:00.840><c> should</c><00:04:01.019><c> give</c><00:04:01.170><c> us</c><00:04:01.290><c> a</c><00:04:01.410><c> pretty</c><00:04:01.440><c> good</c>

00:04:01.729 --> 00:04:01.739 align:start position:0%
so this should give us a pretty good
 

00:04:01.739 --> 00:04:04.520 align:start position:0%
so this should give us a pretty good
range<00:04:02.300><c> will</c><00:04:03.300><c> need</c><00:04:03.450><c> to</c><00:04:03.570><c> use</c><00:04:03.720><c> a</c><00:04:03.750><c> syntax</c><00:04:04.290><c> that</c>

00:04:04.520 --> 00:04:04.530 align:start position:0%
range will need to use a syntax that
 

00:04:04.530 --> 00:04:06.259 align:start position:0%
range will need to use a syntax that
looks<00:04:04.739><c> at</c><00:04:04.920><c> the</c><00:04:05.070><c> beginning</c><00:04:05.430><c> of</c><00:04:05.700><c> each</c><00:04:05.910><c> phone</c>

00:04:06.259 --> 00:04:06.269 align:start position:0%
looks at the beginning of each phone
 

00:04:06.269 --> 00:04:10.310 align:start position:0%
looks at the beginning of each phone
number<00:04:06.630><c> so</c><00:04:07.320><c> type</c><00:04:07.530><c> like</c><00:04:08.130><c> and</c><00:04:08.690><c> in</c><00:04:09.690><c> parentheses</c>

00:04:10.310 --> 00:04:10.320 align:start position:0%
number so type like and in parentheses
 

00:04:10.320 --> 00:04:13.819 align:start position:0%
number so type like and in parentheses
type<00:04:10.739><c> quote</c><00:04:11.340><c> nine</c><00:04:11.820><c> one</c><00:04:12.060><c> nine</c><00:04:12.709><c> asterisk</c>

00:04:13.819 --> 00:04:13.829 align:start position:0%
type quote nine one nine asterisk
 

00:04:13.829 --> 00:04:17.690 align:start position:0%
type quote nine one nine asterisk
end<00:04:13.980><c> quote</c><00:04:15.470><c> the</c><00:04:16.470><c> asterisk</c><00:04:16.829><c> means</c><00:04:17.190><c> that</c><00:04:17.459><c> any</c>

00:04:17.690 --> 00:04:17.700 align:start position:0%
end quote the asterisk means that any
 

00:04:17.700 --> 00:04:19.580 align:start position:0%
end quote the asterisk means that any
phone<00:04:18.000><c> number</c><00:04:18.299><c> can</c><00:04:18.450><c> come</c><00:04:18.690><c> after</c><00:04:19.049><c> the</c><00:04:19.169><c> nine</c><00:04:19.380><c> one</c>

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

00:04:19.590 --> 00:04:21.920 align:start position:0%
phone number can come after the nine one
nine<00:04:19.620><c> area</c><00:04:20.160><c> code</c><00:04:20.400><c> and</c><00:04:20.609><c> there</c><00:04:21.390><c> are</c><00:04:21.510><c> many</c><00:04:21.720><c> other</c>

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

00:04:21.930 --> 00:04:23.930 align:start position:0%
nine area code and there are many other
syntaxes<00:04:22.560><c> that</c><00:04:22.710><c> you</c><00:04:22.800><c> can</c><00:04:22.950><c> use</c><00:04:23.160><c> and</c><00:04:23.370><c> in</c><00:04:23.850><c> the</c>

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

00:04:23.940 --> 00:04:25.280 align:start position:0%
syntaxes that you can use and in the
next<00:04:24.090><c> video</c><00:04:24.360><c> we'll</c><00:04:24.570><c> look</c><00:04:24.660><c> at</c><00:04:24.780><c> a</c><00:04:24.810><c> few</c><00:04:24.900><c> other</c>

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

00:04:25.290 --> 00:04:28.190 align:start position:0%
next video we'll look at a few other
examples<00:04:25.380><c> of</c><00:04:25.950><c> these</c><00:04:26.479><c> now</c><00:04:27.479><c> in</c><00:04:27.600><c> this</c><00:04:27.720><c> case</c><00:04:27.960><c> we're</c>

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

00:04:28.200 --> 00:04:30.020 align:start position:0%
examples of these now in this case we're
putting<00:04:28.500><c> the</c><00:04:28.590><c> criteria</c><00:04:29.100><c> on</c><00:04:29.280><c> the</c><00:04:29.310><c> same</c><00:04:29.760><c> row</c>

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

00:04:30.030 --> 00:04:32.000 align:start position:0%
putting the criteria on the same row
because<00:04:30.810><c> we</c><00:04:30.960><c> want</c><00:04:31.140><c> the</c><00:04:31.260><c> customers</c><00:04:31.710><c> to</c><00:04:31.860><c> meet</c>

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

00:04:32.010 --> 00:04:34.550 align:start position:0%
because we want the customers to meet
both<00:04:32.280><c> of</c><00:04:32.310><c> these</c><00:04:32.580><c> criteria</c><00:04:32.850><c> if</c><00:04:33.330><c> they</c><00:04:34.140><c> just</c><00:04:34.380><c> meet</c>

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

00:04:34.560 --> 00:04:35.990 align:start position:0%
both of these criteria if they just meet
one<00:04:34.800><c> of</c><00:04:34.830><c> the</c><00:04:35.010><c> criteria</c><00:04:35.040><c> then</c><00:04:35.760><c> they're</c><00:04:35.880><c> not</c>

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

00:04:36.000 --> 00:04:37.400 align:start position:0%
one of the criteria then they're not
going<00:04:36.270><c> to</c><00:04:36.330><c> be</c><00:04:36.450><c> included</c><00:04:36.930><c> in</c><00:04:37.050><c> the</c><00:04:37.200><c> query</c>

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

00:04:37.410 --> 00:04:39.950 align:start position:0%
going to be included in the query
results<00:04:37.919><c> if</c><00:04:38.070><c> we</c><00:04:38.880><c> needed</c><00:04:39.090><c> them</c><00:04:39.300><c> to</c><00:04:39.450><c> meet</c><00:04:39.600><c> one</c><00:04:39.810><c> or</c>

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

00:04:39.960 --> 00:04:41.630 align:start position:0%
results if we needed them to meet one or
the<00:04:40.050><c> other</c><00:04:40.229><c> then</c><00:04:40.680><c> we</c><00:04:40.740><c> would</c><00:04:41.010><c> put</c><00:04:41.190><c> one</c><00:04:41.400><c> of</c><00:04:41.520><c> these</c>

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

00:04:41.640 --> 00:04:47.450 align:start position:0%
the other then we would put one of these
criteria<00:04:42.210><c> on</c><00:04:42.390><c> the</c><00:04:42.419><c> next</c><00:04:42.840><c> row</c><00:04:45.919><c> this</c><00:04:46.919><c> query</c><00:04:47.220><c> is</c>

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

00:04:47.460 --> 00:04:49.730 align:start position:0%
criteria on the next row this query is
finished<00:04:47.790><c> now</c><00:04:48.000><c> so</c><00:04:48.210><c> we</c><00:04:48.780><c> can</c><00:04:48.960><c> run</c><00:04:49.169><c> it</c><00:04:49.320><c> to</c><00:04:49.440><c> see</c><00:04:49.470><c> the</c>

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

00:04:49.740 --> 00:04:52.550 align:start position:0%
finished now so we can run it to see the
results<00:04:49.770><c> and</c><00:04:50.310><c> you</c><00:04:50.840><c> can</c><00:04:51.840><c> see</c><00:04:51.990><c> that</c><00:04:52.320><c> each</c>

00:04:52.550 --> 00:04:52.560 align:start position:0%
results and you can see that each
 

00:04:52.560 --> 00:04:55.130 align:start position:0%
results and you can see that each
customer<00:04:52.860><c> meets</c><00:04:53.310><c> both</c><00:04:53.580><c> criteria</c><00:04:53.960><c> they</c><00:04:54.960><c> are</c>

00:04:55.130 --> 00:04:55.140 align:start position:0%
customer meets both criteria they are
 

00:04:55.140 --> 00:04:57.110 align:start position:0%
customer meets both criteria they are
not<00:04:55.320><c> from</c><00:04:55.530><c> Raleigh</c><00:04:55.770><c> and</c><00:04:56.039><c> their</c><00:04:56.640><c> phone</c><00:04:56.820><c> numbers</c>

00:04:57.110 --> 00:04:57.120 align:start position:0%
not from Raleigh and their phone numbers
 

00:04:57.120 --> 00:05:00.529 align:start position:0%
not from Raleigh and their phone numbers
begin<00:04:57.479><c> with</c><00:04:57.660><c> nine</c><00:04:57.900><c> one</c><00:04:58.140><c> nine</c><00:04:59.120><c> so</c><00:05:00.120><c> generally</c>

00:05:00.529 --> 00:05:00.539 align:start position:0%
begin with nine one nine so generally
 

00:05:00.539 --> 00:05:02.330 align:start position:0%
begin with nine one nine so generally
more<00:05:00.750><c> complex</c><00:05:01.020><c> queries</c><00:05:01.650><c> require</c><00:05:02.039><c> more</c>

00:05:02.330 --> 00:05:02.340 align:start position:0%
more complex queries require more
 

00:05:02.340 --> 00:05:04.340 align:start position:0%
more complex queries require more
planning<00:05:02.539><c> but</c><00:05:03.539><c> you</c><00:05:03.660><c> can</c><00:05:03.810><c> make</c><00:05:03.930><c> it</c><00:05:04.050><c> a</c><00:05:04.110><c> lot</c>

00:05:04.340 --> 00:05:04.350 align:start position:0%
planning but you can make it a lot
 

00:05:04.350 --> 00:05:06.380 align:start position:0%
planning but you can make it a lot
easier<00:05:04.380><c> by</c><00:05:04.919><c> just</c><00:05:04.950><c> following</c><00:05:05.669><c> the</c><00:05:05.789><c> four</c><00:05:06.060><c> steps</c>

00:05:06.380 --> 00:05:06.390 align:start position:0%
easier by just following the four steps
 

00:05:06.390 --> 00:05:08.719 align:start position:0%
easier by just following the four steps
of<00:05:06.710><c> pinpointing</c><00:05:07.710><c> exactly</c><00:05:08.250><c> what</c><00:05:08.400><c> you</c><00:05:08.490><c> want</c><00:05:08.669><c> to</c>

00:05:08.719 --> 00:05:08.729 align:start position:0%
of pinpointing exactly what you want to
 

00:05:08.729 --> 00:05:11.180 align:start position:0%
of pinpointing exactly what you want to
find<00:05:08.940><c> out</c><00:05:09.410><c> identifying</c><00:05:10.410><c> the</c><00:05:10.590><c> information</c>

00:05:11.180 --> 00:05:11.190 align:start position:0%
find out identifying the information
 

00:05:11.190 --> 00:05:13.610 align:start position:0%
find out identifying the information
that<00:05:11.340><c> you</c><00:05:11.430><c> need</c><00:05:12.020><c> locating</c><00:05:13.020><c> the</c><00:05:13.140><c> tables</c><00:05:13.530><c> that</c>

00:05:13.610 --> 00:05:13.620 align:start position:0%
that you need locating the tables that
 

00:05:13.620 --> 00:05:15.950 align:start position:0%
that you need locating the tables that
contain<00:05:13.830><c> the</c><00:05:14.220><c> information</c><00:05:14.760><c> and</c><00:05:14.960><c> determining</c>

00:05:15.950 --> 00:05:15.960 align:start position:0%
contain the information and determining
 

00:05:15.960 --> 00:05:19.040 align:start position:0%
contain the information and determining
exactly<00:05:16.110><c> what</c><00:05:16.740><c> criteria</c><00:05:17.280><c> you</c><00:05:17.490><c> need</c><00:05:17.700><c> and</c><00:05:18.050><c> in</c>

00:05:19.040 --> 00:05:19.050 align:start position:0%
exactly what criteria you need and in
 

00:05:19.050 --> 00:05:20.420 align:start position:0%
exactly what criteria you need and in
the<00:05:19.140><c> next</c><00:05:19.380><c> video</c><00:05:19.620><c> we're</c><00:05:19.830><c> going</c><00:05:20.039><c> to</c><00:05:20.130><c> look</c><00:05:20.250><c> at</c>

00:05:20.420 --> 00:05:20.430 align:start position:0%
the next video we're going to look at
 

00:05:20.430 --> 00:05:22.370 align:start position:0%
the next video we're going to look at
joins<00:05:20.789><c> and</c><00:05:21.060><c> search</c><00:05:21.539><c> criteria</c>

00:05:22.370 --> 00:05:22.380 align:start position:0%
joins and search criteria
 

00:05:22.380 --> 00:05:25.370 align:start position:0%
joins and search criteria
a little<00:05:22.680><c> bit</c><00:05:22.800><c> more</c><00:05:22.980><c> detail</c>