WEBVTT
Kind: captions
Language: en

00:00:01.159 --> 00:00:03.740 align:start position:0%
 
Goodwill<00:00:02.159><c> Community</c><00:00:02.639><c> Foundation</c><00:00:03.270><c> creating</c>

00:00:03.740 --> 00:00:03.750 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.750 --> 00:00:08.419 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.350><c> for</c><00:00:04.560><c> a</c><00:00:04.620><c> better</c><00:00:04.650><c> life</c><00:00:04.830><c> in</c><00:00:07.429><c> the</c>

00:00:08.419 --> 00:00:08.429 align:start position:0%
opportunities for a better life in the
 

00:00:08.429 --> 00:00:10.310 align:start position:0%
opportunities for a better life in the
last<00:00:08.580><c> video</c><00:00:08.910><c> we</c><00:00:09.150><c> created</c><00:00:09.179><c> a</c><00:00:09.630><c> query</c><00:00:09.900><c> that</c><00:00:09.960><c> used</c>

00:00:10.310 --> 00:00:10.320 align:start position:0%
last video we created a query that used
 

00:00:10.320 --> 00:00:12.799 align:start position:0%
last video we created a query that used
two<00:00:10.679><c> tables</c><00:00:11.160><c> and</c><00:00:11.280><c> we</c><00:00:11.370><c> just</c><00:00:12.120><c> wanted</c><00:00:12.420><c> our</c><00:00:12.509><c> query</c>

00:00:12.799 --> 00:00:12.809 align:start position:0%
two tables and we just wanted our query
 

00:00:12.809 --> 00:00:14.660 align:start position:0%
two tables and we just wanted our query
to<00:00:12.990><c> include</c><00:00:13.320><c> customers</c><00:00:13.860><c> who</c><00:00:14.009><c> have</c><00:00:14.160><c> placed</c><00:00:14.340><c> an</c>

00:00:14.660 --> 00:00:14.670 align:start position:0%
to include customers who have placed an
 

00:00:14.670 --> 00:00:17.150 align:start position:0%
to include customers who have placed an
order<00:00:14.820><c> at</c><00:00:15.000><c> our</c><00:00:15.179><c> bakery</c><00:00:15.680><c> now</c><00:00:16.680><c> we're</c><00:00:16.859><c> going</c><00:00:17.070><c> to</c>

00:00:17.150 --> 00:00:17.160 align:start position:0%
order at our bakery now we're going to
 

00:00:17.160 --> 00:00:19.070 align:start position:0%
order at our bakery now we're going to
talk<00:00:17.340><c> about</c><00:00:17.369><c> why</c><00:00:17.940><c> we</c><00:00:18.180><c> chose</c><00:00:18.210><c> the</c><00:00:18.539><c> type</c><00:00:18.720><c> of</c><00:00:18.869><c> join</c>

00:00:19.070 --> 00:00:19.080 align:start position:0%
talk about why we chose the type of join
 

00:00:19.080 --> 00:00:20.900 align:start position:0%
talk about why we chose the type of join
that<00:00:19.230><c> we</c><00:00:19.350><c> did</c><00:00:19.529><c> and</c><00:00:19.740><c> we're</c><00:00:20.189><c> also</c><00:00:20.340><c> going</c><00:00:20.670><c> to</c><00:00:20.789><c> look</c>

00:00:20.900 --> 00:00:20.910 align:start position:0%
that we did and we're also going to look
 

00:00:20.910 --> 00:00:22.880 align:start position:0%
that we did and we're also going to look
at<00:00:21.029><c> some</c><00:00:21.180><c> examples</c><00:00:21.630><c> of</c><00:00:21.840><c> search</c><00:00:22.140><c> criteria</c><00:00:22.350><c> that</c>

00:00:22.880 --> 00:00:22.890 align:start position:0%
at some examples of search criteria that
 

00:00:22.890 --> 00:00:24.640 align:start position:0%
at some examples of search criteria that
you<00:00:23.010><c> can</c><00:00:23.160><c> use</c><00:00:23.310><c> to</c><00:00:23.490><c> narrow</c><00:00:23.640><c> down</c><00:00:23.910><c> your</c><00:00:24.119><c> queries</c>

00:00:24.640 --> 00:00:24.650 align:start position:0%
you can use to narrow down your queries
 

00:00:24.650 --> 00:00:27.529 align:start position:0%
you can use to narrow down your queries
in<00:00:25.650><c> this</c><00:00:25.859><c> example</c><00:00:26.189><c> we</c><00:00:26.430><c> chose</c><00:00:26.699><c> a</c><00:00:26.730><c> right-to-left</c>

00:00:27.529 --> 00:00:27.539 align:start position:0%
in this example we chose a right-to-left
 

00:00:27.539 --> 00:00:29.810 align:start position:0%
in this example we chose a right-to-left
join<00:00:28.140><c> because</c><00:00:28.650><c> we</c><00:00:28.800><c> wanted</c><00:00:29.039><c> the</c><00:00:29.099><c> query</c><00:00:29.429><c> to</c><00:00:29.609><c> pull</c>

00:00:29.810 --> 00:00:29.820 align:start position:0%
join because we wanted the query to pull
 

00:00:29.820 --> 00:00:31.220 align:start position:0%
join because we wanted the query to pull
in<00:00:29.939><c> the</c><00:00:30.060><c> records</c><00:00:30.390><c> from</c><00:00:30.539><c> the</c><00:00:30.630><c> orders</c><00:00:31.050><c> table</c>

00:00:31.220 --> 00:00:31.230 align:start position:0%
in the records from the orders table
 

00:00:31.230 --> 00:00:33.560 align:start position:0%
in the records from the orders table
first<00:00:31.619><c> and</c><00:00:31.949><c> then</c><00:00:32.520><c> use</c><00:00:32.700><c> the</c><00:00:32.880><c> information</c><00:00:33.120><c> in</c>

00:00:33.560 --> 00:00:33.570 align:start position:0%
first and then use the information in
 

00:00:33.570 --> 00:00:35.330 align:start position:0%
first and then use the information in
those<00:00:33.750><c> records</c><00:00:33.930><c> to</c><00:00:34.440><c> retrieve</c><00:00:34.800><c> the</c><00:00:35.010><c> records</c>

00:00:35.330 --> 00:00:35.340 align:start position:0%
those records to retrieve the records
 

00:00:35.340 --> 00:00:37.880 align:start position:0%
those records to retrieve the records
from<00:00:35.520><c> the</c><00:00:35.670><c> customers</c><00:00:36.120><c> table</c><00:00:36.440><c> to</c><00:00:37.440><c> understand</c>

00:00:37.880 --> 00:00:37.890 align:start position:0%
from the customers table to understand
 

00:00:37.890 --> 00:00:39.470 align:start position:0%
from the customers table to understand
how<00:00:38.040><c> this</c><00:00:38.190><c> works</c><00:00:38.250><c> let's</c><00:00:38.940><c> look</c><00:00:39.030><c> at</c><00:00:39.210><c> how</c><00:00:39.329><c> these</c>

00:00:39.470 --> 00:00:39.480 align:start position:0%
how this works let's look at how these
 

00:00:39.480 --> 00:00:42.410 align:start position:0%
how this works let's look at how these
tables<00:00:39.899><c> are</c><00:00:39.989><c> connected</c><00:00:40.910><c> every</c><00:00:41.910><c> time</c><00:00:42.120><c> an</c><00:00:42.239><c> order</c>

00:00:42.410 --> 00:00:42.420 align:start position:0%
tables are connected every time an order
 

00:00:42.420 --> 00:00:44.389 align:start position:0%
tables are connected every time an order
is<00:00:42.629><c> placed</c><00:00:42.840><c> it's</c><00:00:43.290><c> connected</c><00:00:43.710><c> with</c><00:00:43.860><c> a</c><00:00:43.890><c> customer</c>

00:00:44.389 --> 00:00:44.399 align:start position:0%
is placed it's connected with a customer
 

00:00:44.399 --> 00:00:46.459 align:start position:0%
is placed it's connected with a customer
and<00:00:44.579><c> if</c><00:00:45.120><c> someone</c><00:00:45.360><c> places</c><00:00:45.600><c> multiple</c><00:00:46.140><c> orders</c>

00:00:46.459 --> 00:00:46.469 align:start position:0%
and if someone places multiple orders
 

00:00:46.469 --> 00:00:47.990 align:start position:0%
and if someone places multiple orders
then<00:00:46.710><c> they'll</c><00:00:46.829><c> be</c><00:00:46.920><c> connected</c><00:00:47.340><c> with</c><00:00:47.489><c> each</c><00:00:47.760><c> of</c>

00:00:47.990 --> 00:00:48.000 align:start position:0%
then they'll be connected with each of
 

00:00:48.000 --> 00:00:50.660 align:start position:0%
then they'll be connected with each of
those<00:00:48.120><c> orders</c><00:00:48.649><c> you'll</c><00:00:49.649><c> notice</c><00:00:49.950><c> that</c><00:00:50.100><c> not</c><00:00:50.370><c> all</c>

00:00:50.660 --> 00:00:50.670 align:start position:0%
those orders you'll notice that not all
 

00:00:50.670 --> 00:00:52.160 align:start position:0%
those orders you'll notice that not all
of<00:00:50.700><c> our</c><00:00:50.910><c> customers</c><00:00:51.390><c> have</c><00:00:51.570><c> placed</c><00:00:51.809><c> an</c><00:00:52.020><c> order</c>

00:00:52.160 --> 00:00:52.170 align:start position:0%
of our customers have placed an order
 

00:00:52.170 --> 00:00:54.590 align:start position:0%
of our customers have placed an order
but<00:00:52.890><c> all</c><00:00:53.160><c> of</c><00:00:53.340><c> the</c><00:00:53.489><c> orders</c><00:00:53.879><c> are</c><00:00:54.030><c> connected</c><00:00:54.480><c> with</c>

00:00:54.590 --> 00:00:54.600 align:start position:0%
but all of the orders are connected with
 

00:00:54.600 --> 00:00:56.600 align:start position:0%
but all of the orders are connected with
a<00:00:54.629><c> customer</c><00:00:55.199><c> and</c><00:00:55.379><c> that's</c><00:00:55.949><c> an</c><00:00:56.070><c> important</c><00:00:56.550><c> thing</c>

00:00:56.600 --> 00:00:56.610 align:start position:0%
a customer and that's an important thing
 

00:00:56.610 --> 00:00:57.889 align:start position:0%
a customer and that's an important thing
to<00:00:56.850><c> keep</c><00:00:57.000><c> in</c><00:00:57.120><c> mind</c><00:00:57.180><c> when</c><00:00:57.539><c> we're</c><00:00:57.690><c> choosing</c>

00:00:57.889 --> 00:00:57.899 align:start position:0%
to keep in mind when we're choosing
 

00:00:57.899 --> 00:01:01.099 align:start position:0%
to keep in mind when we're choosing
which<00:00:58.230><c> type</c><00:00:58.469><c> of</c><00:00:58.530><c> join</c><00:00:58.710><c> to</c><00:00:59.070><c> use</c><00:00:59.809><c> let's</c><00:01:00.809><c> look</c><00:01:00.989><c> at</c>

00:01:01.099 --> 00:01:01.109 align:start position:0%
which type of join to use let's look at
 

00:01:01.109 --> 00:01:02.599 align:start position:0%
which type of join to use let's look at
what<00:01:01.320><c> would</c><00:01:01.469><c> happen</c><00:01:01.800><c> if</c><00:01:01.949><c> we</c><00:01:02.100><c> connected</c><00:01:02.520><c> these</c>

00:01:02.599 --> 00:01:02.609 align:start position:0%
what would happen if we connected these
 

00:01:02.609 --> 00:01:05.509 align:start position:0%
what would happen if we connected these
tables<00:01:03.030><c> with</c><00:01:03.239><c> a</c><00:01:03.270><c> left-to-right</c><00:01:03.960><c> join</c><00:01:04.519><c> first</c>

00:01:05.509 --> 00:01:05.519 align:start position:0%
tables with a left-to-right join first
 

00:01:05.519 --> 00:01:07.760 align:start position:0%
tables with a left-to-right join first
access<00:01:06.180><c> retrieves</c><00:01:06.689><c> all</c><00:01:06.930><c> of</c><00:01:07.170><c> the</c><00:01:07.260><c> records</c><00:01:07.619><c> from</c>

00:01:07.760 --> 00:01:07.770 align:start position:0%
access retrieves all of the records from
 

00:01:07.770 --> 00:01:09.740 align:start position:0%
access retrieves all of the records from
the<00:01:07.860><c> customers</c><00:01:07.979><c> table</c><00:01:08.610><c> and</c><00:01:08.939><c> then</c><00:01:09.450><c> it</c><00:01:09.540><c> uses</c>

00:01:09.740 --> 00:01:09.750 align:start position:0%
the customers table and then it uses
 

00:01:09.750 --> 00:01:11.539 align:start position:0%
the customers table and then it uses
this<00:01:10.140><c> list</c><00:01:10.409><c> to</c><00:01:10.590><c> get</c><00:01:10.710><c> all</c><00:01:10.920><c> of</c><00:01:11.070><c> the</c><00:01:11.189><c> orders</c><00:01:11.520><c> that</c>

00:01:11.539 --> 00:01:11.549 align:start position:0%
this list to get all of the orders that
 

00:01:11.549 --> 00:01:14.120 align:start position:0%
this list to get all of the orders that
are<00:01:11.790><c> connected</c><00:01:12.210><c> with</c><00:01:12.240><c> a</c><00:01:12.390><c> customer</c><00:01:12.920><c> that</c><00:01:13.920><c> means</c>

00:01:14.120 --> 00:01:14.130 align:start position:0%
are connected with a customer that means
 

00:01:14.130 --> 00:01:16.130 align:start position:0%
are connected with a customer that means
the<00:01:14.280><c> query</c><00:01:14.549><c> is</c><00:01:14.729><c> going</c><00:01:14.970><c> to</c><00:01:15.090><c> include</c><00:01:15.390><c> all</c><00:01:15.659><c> of</c><00:01:16.020><c> the</c>

00:01:16.130 --> 00:01:16.140 align:start position:0%
the query is going to include all of the
 

00:01:16.140 --> 00:01:17.840 align:start position:0%
the query is going to include all of the
customer<00:01:16.560><c> records</c><00:01:16.950><c> even</c><00:01:17.340><c> if</c><00:01:17.580><c> they're</c><00:01:17.729><c> not</c>

00:01:17.840 --> 00:01:17.850 align:start position:0%
customer records even if they're not
 

00:01:17.850 --> 00:01:19.640 align:start position:0%
customer records even if they're not
connected<00:01:18.240><c> with</c><00:01:18.270><c> an</c><00:01:18.509><c> order</c><00:01:18.810><c> and</c><00:01:18.990><c> this</c><00:01:19.350><c> is</c><00:01:19.500><c> not</c>

00:01:19.640 --> 00:01:19.650 align:start position:0%
connected with an order and this is not
 

00:01:19.650 --> 00:01:22.520 align:start position:0%
connected with an order and this is not
what<00:01:19.860><c> we</c><00:01:20.009><c> want</c><00:01:20.509><c> instead</c><00:01:21.509><c> we</c><00:01:21.840><c> want</c><00:01:22.049><c> to</c><00:01:22.110><c> use</c><00:01:22.320><c> the</c>

00:01:22.520 --> 00:01:22.530 align:start position:0%
what we want instead we want to use the
 

00:01:22.530 --> 00:01:24.469 align:start position:0%
what we want instead we want to use the
order<00:01:22.740><c> records</c><00:01:23.280><c> to</c><00:01:23.490><c> just</c><00:01:23.850><c> pull</c><00:01:24.119><c> in</c><00:01:24.330><c> the</c>

00:01:24.469 --> 00:01:24.479 align:start position:0%
order records to just pull in the
 

00:01:24.479 --> 00:01:26.510 align:start position:0%
order records to just pull in the
customers<00:01:24.900><c> who</c><00:01:25.020><c> have</c><00:01:25.140><c> placed</c><00:01:25.290><c> an</c><00:01:25.560><c> order</c><00:01:25.680><c> we</c>

00:01:26.510 --> 00:01:26.520 align:start position:0%
customers who have placed an order we
 

00:01:26.520 --> 00:01:28.460 align:start position:0%
customers who have placed an order we
can<00:01:26.700><c> do</c><00:01:26.790><c> this</c><00:01:26.939><c> by</c><00:01:27.150><c> choosing</c><00:01:27.420><c> a</c><00:01:27.750><c> right-to-left</c>

00:01:28.460 --> 00:01:28.470 align:start position:0%
can do this by choosing a right-to-left
 

00:01:28.470 --> 00:01:31.640 align:start position:0%
can do this by choosing a right-to-left
join<00:01:29.150><c> now</c><00:01:30.150><c> the</c><00:01:30.210><c> query</c><00:01:30.689><c> will</c><00:01:30.869><c> first</c><00:01:31.200><c> retrieve</c>

00:01:31.640 --> 00:01:31.650 align:start position:0%
join now the query will first retrieve
 

00:01:31.650 --> 00:01:33.319 align:start position:0%
join now the query will first retrieve
all<00:01:31.890><c> of</c><00:01:32.040><c> the</c><00:01:32.130><c> records</c><00:01:32.460><c> from</c><00:01:32.610><c> the</c><00:01:32.700><c> orders</c><00:01:33.150><c> table</c>

00:01:33.319 --> 00:01:33.329 align:start position:0%
all of the records from the orders table
 

00:01:33.329 --> 00:01:35.719 align:start position:0%
all of the records from the orders table
and<00:01:33.659><c> it</c><00:01:34.290><c> will</c><00:01:34.380><c> then</c><00:01:34.560><c> use</c><00:01:34.740><c> that</c><00:01:34.770><c> list</c><00:01:35.280><c> to</c><00:01:35.490><c> find</c>

00:01:35.719 --> 00:01:35.729 align:start position:0%
and it will then use that list to find
 

00:01:35.729 --> 00:01:37.490 align:start position:0%
and it will then use that list to find
all<00:01:35.970><c> of</c><00:01:36.119><c> the</c><00:01:36.210><c> customers</c><00:01:36.659><c> who</c><00:01:36.689><c> are</c><00:01:36.840><c> connected</c>

00:01:37.490 --> 00:01:37.500 align:start position:0%
all of the customers who are connected
 

00:01:37.500 --> 00:01:41.300 align:start position:0%
all of the customers who are connected
with<00:01:37.680><c> at</c><00:01:37.829><c> least</c><00:01:37.950><c> one</c><00:01:38.250><c> order</c>

00:01:41.300 --> 00:01:41.310 align:start position:0%
 
 

00:01:41.310 --> 00:01:43.680 align:start position:0%
 
so<00:01:42.310><c> whenever</c><00:01:42.520><c> you're</c><00:01:42.760><c> creating</c><00:01:43.180><c> a</c><00:01:43.270><c> query</c><00:01:43.450><c> with</c>

00:01:43.680 --> 00:01:43.690 align:start position:0%
so whenever you're creating a query with
 

00:01:43.690 --> 00:01:45.660 align:start position:0%
so whenever you're creating a query with
multiple<00:01:44.140><c> tables</c><00:01:44.350><c> you'll</c><00:01:45.010><c> need</c><00:01:45.280><c> to</c><00:01:45.400><c> decide</c>

00:01:45.660 --> 00:01:45.670 align:start position:0%
multiple tables you'll need to decide
 

00:01:45.670 --> 00:01:48.480 align:start position:0%
multiple tables you'll need to decide
which<00:01:45.909><c> type</c><00:01:46.210><c> of</c><00:01:46.240><c> join</c><00:01:46.390><c> to</c><00:01:46.720><c> use</c><00:01:47.040><c> you</c><00:01:48.040><c> can</c><00:01:48.220><c> double</c>

00:01:48.480 --> 00:01:48.490 align:start position:0%
which type of join to use you can double
 

00:01:48.490 --> 00:01:51.030 align:start position:0%
which type of join to use you can double
click<00:01:48.520><c> the</c><00:01:48.820><c> join</c><00:01:48.970><c> to</c><00:01:49.180><c> change</c><00:01:49.450><c> it</c><00:01:49.600><c> and</c><00:01:50.040><c> then</c>

00:01:51.030 --> 00:01:51.040 align:start position:0%
click the join to change it and then
 

00:01:51.040 --> 00:01:53.580 align:start position:0%
click the join to change it and then
choose<00:01:51.369><c> option</c><00:01:52.000><c> 2</c><00:01:52.270><c> for</c><00:01:52.690><c> left</c><00:01:52.930><c> to</c><00:01:53.080><c> right</c><00:01:53.290><c> join</c>

00:01:53.580 --> 00:01:53.590 align:start position:0%
choose option 2 for left to right join
 

00:01:53.590 --> 00:02:01.109 align:start position:0%
choose option 2 for left to right join
or<00:01:54.310><c> option</c><00:01:55.030><c> 3</c><00:01:55.390><c> for</c><00:01:55.690><c> a</c><00:01:55.720><c> right</c><00:01:56.020><c> to</c><00:01:56.200><c> left</c><00:01:56.380><c> join</c><00:02:00.119><c> we</c>

00:02:01.109 --> 00:02:01.119 align:start position:0%
or option 3 for a right to left join we
 

00:02:01.119 --> 00:02:02.850 align:start position:0%
or option 3 for a right to left join we
are<00:02:01.270><c> also</c><00:02:01.450><c> narrowing</c><00:02:02.080><c> down</c><00:02:02.110><c> our</c><00:02:02.290><c> query</c><00:02:02.650><c> by</c>

00:02:02.850 --> 00:02:02.860 align:start position:0%
are also narrowing down our query by
 

00:02:02.860 --> 00:02:05.070 align:start position:0%
are also narrowing down our query by
using<00:02:03.100><c> search</c><00:02:03.520><c> criteria</c><00:02:04.150><c> in</c><00:02:04.330><c> the</c><00:02:04.570><c> city</c><00:02:04.810><c> and</c>

00:02:05.070 --> 00:02:05.080 align:start position:0%
using search criteria in the city and
 

00:02:05.080 --> 00:02:07.140 align:start position:0%
using search criteria in the city and
phone<00:02:05.350><c> number</c><00:02:05.650><c> fields</c><00:02:06.040><c> you</c><00:02:06.790><c> may</c><00:02:06.909><c> remember</c>

00:02:07.140 --> 00:02:07.150 align:start position:0%
phone number fields you may remember
 

00:02:07.150 --> 00:02:08.820 align:start position:0%
phone number fields you may remember
that<00:02:07.420><c> search</c><00:02:07.600><c> criteria</c><00:02:07.810><c> have</c><00:02:08.380><c> to</c><00:02:08.530><c> be</c><00:02:08.619><c> written</c>

00:02:08.820 --> 00:02:08.830 align:start position:0%
that search criteria have to be written
 

00:02:08.830 --> 00:02:10.919 align:start position:0%
that search criteria have to be written
with<00:02:08.950><c> a</c><00:02:09.130><c> very</c><00:02:09.429><c> specific</c><00:02:09.729><c> syntax</c><00:02:10.300><c> so</c><00:02:10.780><c> that</c>

00:02:10.919 --> 00:02:10.929 align:start position:0%
with a very specific syntax so that
 

00:02:10.929 --> 00:02:12.750 align:start position:0%
with a very specific syntax so that
access<00:02:11.260><c> can</c><00:02:11.470><c> understand</c><00:02:11.920><c> them</c><00:02:12.070><c> and</c><00:02:12.220><c> they'll</c>

00:02:12.750 --> 00:02:12.760 align:start position:0%
access can understand them and they'll
 

00:02:12.760 --> 00:02:14.699 align:start position:0%
access can understand them and they'll
often<00:02:13.180><c> need</c><00:02:13.360><c> to</c><00:02:13.390><c> include</c><00:02:13.840><c> quotation</c><00:02:14.410><c> marks</c>

00:02:14.699 --> 00:02:14.709 align:start position:0%
often need to include quotation marks
 

00:02:14.709 --> 00:02:16.440 align:start position:0%
often need to include quotation marks
and<00:02:14.950><c> parentheses</c><00:02:15.550><c> in</c><00:02:15.730><c> order</c><00:02:15.910><c> to</c><00:02:16.000><c> be</c><00:02:16.120><c> correct</c>

00:02:16.440 --> 00:02:16.450 align:start position:0%
and parentheses in order to be correct
 

00:02:16.450 --> 00:02:18.690 align:start position:0%
and parentheses in order to be correct
so<00:02:17.410><c> let's</c><00:02:17.440><c> look</c><00:02:17.769><c> at</c><00:02:17.860><c> a</c><00:02:17.890><c> few</c><00:02:18.190><c> of</c><00:02:18.280><c> the</c><00:02:18.400><c> different</c>

00:02:18.690 --> 00:02:18.700 align:start position:0%
so let's look at a few of the different
 

00:02:18.700 --> 00:02:22.320 align:start position:0%
so let's look at a few of the different
syntaxes<00:02:19.209><c> that</c><00:02:19.390><c> you</c><00:02:19.480><c> can</c><00:02:19.660><c> use</c><00:02:19.900><c> if</c><00:02:21.330><c> you're</c>

00:02:22.320 --> 00:02:22.330 align:start position:0%
syntaxes that you can use if you're
 

00:02:22.330 --> 00:02:24.570 align:start position:0%
syntaxes that you can use if you're
looking<00:02:22.690><c> for</c><00:02:22.930><c> an</c><00:02:23.050><c> exact</c><00:02:23.440><c> match</c><00:02:23.709><c> then</c><00:02:24.280><c> you</c><00:02:24.459><c> can</c>

00:02:24.570 --> 00:02:24.580 align:start position:0%
looking for an exact match then you can
 

00:02:24.580 --> 00:02:26.400 align:start position:0%
looking for an exact match then you can
just<00:02:24.730><c> put</c><00:02:24.940><c> your</c><00:02:25.060><c> search</c><00:02:25.269><c> terms</c><00:02:25.660><c> in</c><00:02:25.870><c> quotation</c>

00:02:26.400 --> 00:02:26.410 align:start position:0%
just put your search terms in quotation
 

00:02:26.410 --> 00:02:29.820 align:start position:0%
just put your search terms in quotation
marks<00:02:26.440><c> if</c><00:02:27.540><c> you</c><00:02:28.540><c> want</c><00:02:28.780><c> to</c><00:02:28.900><c> exclude</c><00:02:29.410><c> something</c>

00:02:29.820 --> 00:02:29.830 align:start position:0%
marks if you want to exclude something
 

00:02:29.830 --> 00:02:32.310 align:start position:0%
marks if you want to exclude something
from<00:02:30.190><c> the</c><00:02:30.310><c> results</c><00:02:30.700><c> then</c><00:02:31.060><c> you</c><00:02:31.090><c> can</c><00:02:31.330><c> use</c><00:02:31.600><c> not</c><00:02:32.050><c> in</c>

00:02:32.310 --> 00:02:32.320 align:start position:0%
from the results then you can use not in
 

00:02:32.320 --> 00:02:34.500 align:start position:0%
from the results then you can use not in
and<00:02:32.680><c> you</c><00:02:33.310><c> can</c><00:02:33.459><c> even</c><00:02:33.610><c> exclude</c><00:02:34.090><c> several</c>

00:02:34.500 --> 00:02:34.510 align:start position:0%
and you can even exclude several
 

00:02:34.510 --> 00:02:35.910 align:start position:0%
and you can even exclude several
different<00:02:34.780><c> things</c><00:02:34.930><c> by</c><00:02:35.200><c> separating</c><00:02:35.709><c> them</c><00:02:35.890><c> with</c>

00:02:35.910 --> 00:02:35.920 align:start position:0%
different things by separating them with
 

00:02:35.920 --> 00:02:40.050 align:start position:0%
different things by separating them with
commas<00:02:36.070><c> if</c><00:02:38.130><c> you're</c><00:02:39.130><c> looking</c><00:02:39.400><c> for</c><00:02:39.550><c> terms</c><00:02:39.820><c> at</c>

00:02:40.050 --> 00:02:40.060 align:start position:0%
commas if you're looking for terms at
 

00:02:40.060 --> 00:02:41.610 align:start position:0%
commas if you're looking for terms at
the<00:02:40.090><c> beginning</c><00:02:40.660><c> or</c><00:02:40.840><c> the</c><00:02:40.870><c> end</c><00:02:41.170><c> of</c><00:02:41.290><c> a</c><00:02:41.410><c> field</c>

00:02:41.610 --> 00:02:41.620 align:start position:0%
the beginning or the end of a field
 

00:02:41.620 --> 00:02:44.039 align:start position:0%
the beginning or the end of a field
you'll<00:02:42.100><c> need</c><00:02:42.280><c> to</c><00:02:42.400><c> use</c><00:02:42.430><c> the</c><00:02:42.850><c> like</c><00:02:43.090><c> syntax</c><00:02:43.510><c> and</c>

00:02:44.039 --> 00:02:44.049 align:start position:0%
you'll need to use the like syntax and
 

00:02:44.049 --> 00:02:46.020 align:start position:0%
you'll need to use the like syntax and
you'll<00:02:44.530><c> notice</c><00:02:44.799><c> that</c><00:02:44.950><c> each</c><00:02:45.160><c> one</c><00:02:45.190><c> of</c><00:02:45.489><c> these</c><00:02:45.700><c> has</c>

00:02:46.020 --> 00:02:46.030 align:start position:0%
you'll notice that each one of these has
 

00:02:46.030 --> 00:02:48.720 align:start position:0%
you'll notice that each one of these has
an<00:02:46.329><c> asterisk</c><00:02:46.750><c> in</c><00:02:47.049><c> it</c><00:02:47.170><c> this</c><00:02:48.100><c> is</c><00:02:48.160><c> known</c><00:02:48.489><c> as</c><00:02:48.519><c> a</c>

00:02:48.720 --> 00:02:48.730 align:start position:0%
an asterisk in it this is known as a
 

00:02:48.730 --> 00:02:51.090 align:start position:0%
an asterisk in it this is known as a
wild-card<00:02:49.480><c> character</c><00:02:49.750><c> which</c><00:02:50.650><c> just</c><00:02:50.890><c> means</c>

00:02:51.090 --> 00:02:51.100 align:start position:0%
wild-card character which just means
 

00:02:51.100 --> 00:02:54.030 align:start position:0%
wild-card character which just means
that<00:02:51.340><c> anything</c><00:02:51.910><c> can</c><00:02:52.060><c> go</c><00:02:52.269><c> here</c><00:02:52.570><c> for</c><00:02:53.500><c> example</c><00:02:53.890><c> if</c>

00:02:54.030 --> 00:02:54.040 align:start position:0%
that anything can go here for example if
 

00:02:54.040 --> 00:02:55.259 align:start position:0%
that anything can go here for example if
you're<00:02:54.190><c> looking</c><00:02:54.489><c> for</c><00:02:54.640><c> phone</c><00:02:54.880><c> numbers</c><00:02:55.239><c> that</c>

00:02:55.259 --> 00:02:55.269 align:start position:0%
you're looking for phone numbers that
 

00:02:55.269 --> 00:02:57.449 align:start position:0%
you're looking for phone numbers that
begin<00:02:55.570><c> with</c><00:02:55.989><c> nine</c><00:02:56.260><c> one</c><00:02:56.500><c> nine</c><00:02:56.530><c> then</c><00:02:57.280><c> you'll</c>

00:02:57.449 --> 00:02:57.459 align:start position:0%
begin with nine one nine then you'll
 

00:02:57.459 --> 00:03:00.300 align:start position:0%
begin with nine one nine then you'll
type<00:02:57.670><c> nine</c><00:02:58.150><c> one</c><00:02:58.420><c> nine</c><00:02:58.470><c> asterisk</c><00:02:59.470><c> and</c><00:02:59.650><c> that</c>

00:03:00.300 --> 00:03:00.310 align:start position:0%
type nine one nine asterisk and that
 

00:03:00.310 --> 00:03:01.890 align:start position:0%
type nine one nine asterisk and that
means<00:03:00.489><c> this</c><00:03:00.670><c> query</c><00:03:00.970><c> will</c><00:03:01.120><c> look</c><00:03:01.269><c> for</c><00:03:01.450><c> nine</c><00:03:01.690><c> one</c>

00:03:01.890 --> 00:03:01.900 align:start position:0%
means this query will look for nine one
 

00:03:01.900 --> 00:03:06.600 align:start position:0%
means this query will look for nine one
nine<00:03:01.930><c> followed</c><00:03:02.829><c> by</c><00:03:03.010><c> anything</c><00:03:03.400><c> and</c><00:03:05.610><c> finally</c>

00:03:06.600 --> 00:03:06.610 align:start position:0%
nine followed by anything and finally
 

00:03:06.610 --> 00:03:08.430 align:start position:0%
nine followed by anything and finally
when<00:03:06.850><c> you're</c><00:03:06.970><c> working</c><00:03:07.299><c> with</c><00:03:07.329><c> numbers</c><00:03:07.870><c> you</c><00:03:08.290><c> can</c>

00:03:08.430 --> 00:03:08.440 align:start position:0%
when you're working with numbers you can
 

00:03:08.440 --> 00:03:10.199 align:start position:0%
when you're working with numbers you can
use<00:03:08.470><c> symbols</c><00:03:09.010><c> such</c><00:03:09.190><c> as</c><00:03:09.220><c> greater</c><00:03:09.670><c> than</c><00:03:09.760><c> and</c>

00:03:10.199 --> 00:03:10.209 align:start position:0%
use symbols such as greater than and
 

00:03:10.209 --> 00:03:12.720 align:start position:0%
use symbols such as greater than and
less<00:03:10.239><c> than</c><00:03:10.660><c> to</c><00:03:11.079><c> test</c><00:03:11.260><c> the</c><00:03:11.440><c> values</c><00:03:11.769><c> and</c><00:03:11.950><c> you</c><00:03:12.579><c> can</c>

00:03:12.720 --> 00:03:12.730 align:start position:0%
less than to test the values and you can
 

00:03:12.730 --> 00:03:14.069 align:start position:0%
less than to test the values and you can
also<00:03:12.850><c> look</c><00:03:13.150><c> for</c><00:03:13.209><c> numbers</c><00:03:13.630><c> that</c><00:03:13.810><c> are</c><00:03:13.930><c> between</c>

00:03:14.069 --> 00:03:14.079 align:start position:0%
also look for numbers that are between
 

00:03:14.079 --> 00:03:17.340 align:start position:0%
also look for numbers that are between
two<00:03:14.470><c> values</c><00:03:15.600><c> so</c><00:03:16.600><c> those</c><00:03:16.750><c> are</c><00:03:16.900><c> some</c><00:03:17.019><c> of</c><00:03:17.079><c> the</c><00:03:17.200><c> most</c>

00:03:17.340 --> 00:03:17.350 align:start position:0%
two values so those are some of the most
 

00:03:17.350 --> 00:03:19.350 align:start position:0%
two values so those are some of the most
common<00:03:17.829><c> syntaxes</c><00:03:18.459><c> that</c><00:03:18.640><c> you</c><00:03:18.730><c> can</c><00:03:18.880><c> use</c><00:03:19.120><c> and</c><00:03:19.329><c> you</c>

00:03:19.350 --> 00:03:19.360 align:start position:0%
common syntaxes that you can use and you
 

00:03:19.360 --> 00:03:22.020 align:start position:0%
common syntaxes that you can use and you
might<00:03:20.049><c> not</c><00:03:20.170><c> use</c><00:03:20.440><c> all</c><00:03:20.470><c> of</c><00:03:20.769><c> these</c><00:03:21.100><c> but</c><00:03:21.370><c> depending</c>

00:03:22.020 --> 00:03:22.030 align:start position:0%
might not use all of these but depending
 

00:03:22.030 --> 00:03:23.670 align:start position:0%
might not use all of these but depending
on<00:03:22.120><c> what</c><00:03:22.180><c> type</c><00:03:22.540><c> of</c><00:03:22.570><c> information</c><00:03:22.989><c> you</c><00:03:23.350><c> have</c><00:03:23.530><c> in</c>

00:03:23.670 --> 00:03:23.680 align:start position:0%
on what type of information you have in
 

00:03:23.680 --> 00:03:25.680 align:start position:0%
on what type of information you have in
your<00:03:23.799><c> database</c><00:03:24.010><c> you</c><00:03:24.670><c> can</c><00:03:24.790><c> probably</c><00:03:25.030><c> find</c><00:03:25.420><c> at</c>

00:03:25.680 --> 00:03:25.690 align:start position:0%
your database you can probably find at
 

00:03:25.690 --> 00:03:27.090 align:start position:0%
your database you can probably find at
least<00:03:25.930><c> two</c><00:03:26.170><c> or</c><00:03:26.290><c> three</c><00:03:26.350><c> that</c><00:03:26.680><c> will</c><00:03:26.769><c> be</c><00:03:26.890><c> useful</c>

00:03:27.090 --> 00:03:27.100 align:start position:0%
least two or three that will be useful
 

00:03:27.100 --> 00:03:29.640 align:start position:0%
least two or three that will be useful
to<00:03:27.370><c> you</c>