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:10.840 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:10.840 --> 00:00:10.850 align:start position:0%
 
 

00:00:10.850 --> 00:00:13.150 align:start position:0%
 
in<00:00:10.910><c> the</c><00:00:11.720><c> last</c><00:00:11.870><c> video</c><00:00:12.200><c> we</c><00:00:12.410><c> created</c><00:00:12.590><c> a</c><00:00:12.920><c> query</c>

00:00:13.150 --> 00:00:13.160 align:start position:0%
in the last video we created a query
 

00:00:13.160 --> 00:00:15.640 align:start position:0%
in the last video we created a query
that<00:00:13.250><c> used</c><00:00:13.580><c> two</c><00:00:13.970><c> tables</c><00:00:14.420><c> and</c><00:00:14.600><c> we</c><00:00:15.080><c> just</c><00:00:15.380><c> wanted</c>

00:00:15.640 --> 00:00:15.650 align:start position:0%
that used two tables and we just wanted
 

00:00:15.650 --> 00:00:17.410 align:start position:0%
that used two tables and we just wanted
our<00:00:15.800><c> query</c><00:00:16.070><c> to</c><00:00:16.250><c> include</c><00:00:16.580><c> customers</c><00:00:17.150><c> who</c><00:00:17.300><c> have</c>

00:00:17.410 --> 00:00:17.420 align:start position:0%
our query to include customers who have
 

00:00:17.420 --> 00:00:20.109 align:start position:0%
our query to include customers who have
placed<00:00:17.600><c> an</c><00:00:17.930><c> order</c><00:00:18.110><c> at</c><00:00:18.410><c> our</c><00:00:18.440><c> bakery</c><00:00:18.940><c> now</c><00:00:19.940><c> we're</c>

00:00:20.109 --> 00:00:20.119 align:start position:0%
placed an order at our bakery now we're
 

00:00:20.119 --> 00:00:21.820 align:start position:0%
placed an order at our bakery now we're
going<00:00:20.300><c> to</c><00:00:20.390><c> talk</c><00:00:20.600><c> about</c><00:00:20.630><c> why</c><00:00:21.230><c> we</c><00:00:21.440><c> chose</c><00:00:21.470><c> the</c>

00:00:21.820 --> 00:00:21.830 align:start position:0%
going to talk about why we chose the
 

00:00:21.830 --> 00:00:23.590 align:start position:0%
going to talk about why we chose the
type<00:00:21.980><c> of</c><00:00:22.130><c> join</c><00:00:22.340><c> that</c><00:00:22.520><c> we</c><00:00:22.610><c> did</c><00:00:22.820><c> and</c><00:00:23.000><c> we're</c><00:00:23.450><c> also</c>

00:00:23.590 --> 00:00:23.600 align:start position:0%
type of join that we did and we're also
 

00:00:23.600 --> 00:00:25.390 align:start position:0%
type of join that we did and we're also
going<00:00:23.930><c> to</c><00:00:24.020><c> look</c><00:00:24.170><c> at</c><00:00:24.260><c> some</c><00:00:24.440><c> examples</c><00:00:24.920><c> of</c><00:00:25.070><c> search</c>

00:00:25.390 --> 00:00:25.400 align:start position:0%
going to look at some examples of search
 

00:00:25.400 --> 00:00:27.160 align:start position:0%
going to look at some examples of search
criteria<00:00:25.610><c> that</c><00:00:26.180><c> you</c><00:00:26.270><c> can</c><00:00:26.420><c> use</c><00:00:26.570><c> to</c><00:00:26.750><c> narrow</c><00:00:26.990><c> down</c>

00:00:27.160 --> 00:00:27.170 align:start position:0%
criteria that you can use to narrow down
 

00:00:27.170 --> 00:00:30.010 align:start position:0%
criteria that you can use to narrow down
your<00:00:27.230><c> queries</c><00:00:27.710><c> in</c><00:00:28.120><c> this</c><00:00:29.120><c> example</c><00:00:29.450><c> we</c><00:00:29.690><c> chose</c><00:00:29.960><c> a</c>

00:00:30.010 --> 00:00:30.020 align:start position:0%
your queries in this example we chose a
 

00:00:30.020 --> 00:00:32.350 align:start position:0%
your queries in this example we chose a
right-to-left<00:00:30.950><c> join</c><00:00:31.400><c> because</c><00:00:31.789><c> we</c><00:00:32.059><c> wanted</c><00:00:32.300><c> the</c>

00:00:32.350 --> 00:00:32.360 align:start position:0%
right-to-left join because we wanted the
 

00:00:32.360 --> 00:00:33.880 align:start position:0%
right-to-left join because we wanted the
query<00:00:32.690><c> to</c><00:00:32.900><c> pull</c><00:00:33.080><c> in</c><00:00:33.200><c> the</c><00:00:33.320><c> records</c><00:00:33.650><c> from</c><00:00:33.800><c> the</c>

00:00:33.880 --> 00:00:33.890 align:start position:0%
query to pull in the records from the
 

00:00:33.890 --> 00:00:36.130 align:start position:0%
query to pull in the records from the
orders<00:00:34.010><c> table</c><00:00:34.520><c> first</c><00:00:34.910><c> and</c><00:00:35.239><c> then</c><00:00:35.780><c> use</c><00:00:35.960><c> the</c>

00:00:36.130 --> 00:00:36.140 align:start position:0%
orders table first and then use the
 

00:00:36.140 --> 00:00:38.080 align:start position:0%
orders table first and then use the
information<00:00:36.379><c> in</c><00:00:36.830><c> those</c><00:00:37.040><c> records</c><00:00:37.340><c> to</c><00:00:37.610><c> retrieve</c>

00:00:38.080 --> 00:00:38.090 align:start position:0%
information in those records to retrieve
 

00:00:38.090 --> 00:00:40.689 align:start position:0%
information in those records to retrieve
the<00:00:38.270><c> records</c><00:00:38.600><c> from</c><00:00:38.780><c> the</c><00:00:38.870><c> customers</c><00:00:39.410><c> table</c><00:00:39.699><c> to</c>

00:00:40.689 --> 00:00:40.699 align:start position:0%
the records from the customers table to
 

00:00:40.699 --> 00:00:42.460 align:start position:0%
the records from the customers table to
understand<00:00:41.180><c> how</c><00:00:41.300><c> this</c><00:00:41.480><c> works</c><00:00:41.750><c> let's</c><00:00:42.020><c> look</c><00:00:42.290><c> at</c>

00:00:42.460 --> 00:00:42.470 align:start position:0%
understand how this works let's look at
 

00:00:42.470 --> 00:00:46.210 align:start position:0%
understand how this works let's look at
how<00:00:42.590><c> these</c><00:00:42.800><c> tables</c><00:00:43.159><c> are</c><00:00:43.280><c> connected</c><00:00:45.220><c> every</c>

00:00:46.210 --> 00:00:46.220 align:start position:0%
how these tables are connected every
 

00:00:46.220 --> 00:00:48.009 align:start position:0%
how these tables are connected every
time<00:00:46.400><c> an</c><00:00:46.550><c> order</c><00:00:46.730><c> is</c><00:00:46.909><c> placed</c><00:00:47.120><c> it's</c><00:00:47.600><c> connected</c>

00:00:48.009 --> 00:00:48.019 align:start position:0%
time an order is placed it's connected
 

00:00:48.019 --> 00:00:49.899 align:start position:0%
time an order is placed it's connected
with<00:00:48.050><c> a</c><00:00:48.199><c> customer</c><00:00:48.710><c> and</c><00:00:48.890><c> if</c><00:00:49.400><c> someone</c><00:00:49.670><c> places</c>

00:00:49.899 --> 00:00:49.909 align:start position:0%
with a customer and if someone places
 

00:00:49.909 --> 00:00:51.219 align:start position:0%
with a customer and if someone places
multiple<00:00:50.449><c> orders</c><00:00:50.780><c> then</c><00:00:51.019><c> they'll</c><00:00:51.140><c> be</c>

00:00:51.219 --> 00:00:51.229 align:start position:0%
multiple orders then they'll be
 

00:00:51.229 --> 00:00:52.950 align:start position:0%
multiple orders then they'll be
connected<00:00:51.650><c> with</c><00:00:51.680><c> each</c><00:00:52.100><c> of</c><00:00:52.280><c> those</c><00:00:52.430><c> orders</c>

00:00:52.950 --> 00:00:52.960 align:start position:0%
connected with each of those orders
 

00:00:52.960 --> 00:00:55.180 align:start position:0%
connected with each of those orders
you'll<00:00:53.960><c> notice</c><00:00:54.260><c> that</c><00:00:54.409><c> not</c><00:00:54.650><c> all</c><00:00:54.710><c> of</c><00:00:55.129><c> our</c>

00:00:55.180 --> 00:00:55.190 align:start position:0%
you'll notice that not all of our
 

00:00:55.190 --> 00:00:57.460 align:start position:0%
you'll notice that not all of our
customers<00:00:55.699><c> have</c><00:00:55.850><c> placed</c><00:00:56.120><c> an</c><00:00:56.300><c> order</c><00:00:56.449><c> but</c><00:00:57.199><c> all</c>

00:00:57.460 --> 00:00:57.470 align:start position:0%
customers have placed an order but all
 

00:00:57.470 --> 00:00:58.930 align:start position:0%
customers have placed an order but all
of<00:00:57.620><c> the</c><00:00:57.769><c> orders</c><00:00:58.159><c> are</c><00:00:58.339><c> connected</c><00:00:58.760><c> with</c><00:00:58.909><c> a</c>

00:00:58.930 --> 00:00:58.940 align:start position:0%
of the orders are connected with a
 

00:00:58.940 --> 00:01:00.880 align:start position:0%
of the orders are connected with a
customer<00:00:59.479><c> and</c><00:00:59.690><c> that's</c><00:01:00.229><c> an</c><00:01:00.379><c> important</c><00:01:00.860><c> thing</c>

00:01:00.880 --> 00:01:00.890 align:start position:0%
customer and that's an important thing
 

00:01:00.890 --> 00:01:02.200 align:start position:0%
customer and that's an important thing
to<00:01:01.129><c> keep</c><00:01:01.280><c> in</c><00:01:01.430><c> mind</c><00:01:01.489><c> when</c><00:01:01.850><c> we're</c><00:01:02.000><c> choosing</c>

00:01:02.200 --> 00:01:02.210 align:start position:0%
to keep in mind when we're choosing
 

00:01:02.210 --> 00:01:05.410 align:start position:0%
to keep in mind when we're choosing
which<00:01:02.540><c> type</c><00:01:02.780><c> of</c><00:01:02.839><c> join</c><00:01:03.019><c> to</c><00:01:03.379><c> use</c><00:01:04.120><c> let's</c><00:01:05.120><c> look</c><00:01:05.269><c> at</c>

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

00:01:05.420 --> 00:01:06.940 align:start position:0%
which type of join to use let's look at
what<00:01:05.600><c> would</c><00:01:05.750><c> happen</c><00:01:06.080><c> if</c><00:01:06.260><c> we</c><00:01:06.409><c> connected</c><00:01:06.830><c> these</c>

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

00:01:06.950 --> 00:01:10.000 align:start position:0%
what would happen if we connected these
tables<00:01:07.340><c> with</c><00:01:07.549><c> a</c><00:01:07.580><c> left-to-right</c><00:01:08.240><c> join</c><00:01:09.010><c> first</c>

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

00:01:10.010 --> 00:01:12.190 align:start position:0%
tables with a left-to-right join first
access<00:01:10.610><c> retrieves</c><00:01:11.120><c> all</c><00:01:11.360><c> of</c><00:01:11.600><c> the</c><00:01:11.720><c> records</c><00:01:12.049><c> from</c>

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

00:01:12.200 --> 00:01:14.170 align:start position:0%
access retrieves all of the records from
the<00:01:12.290><c> customers</c><00:01:12.409><c> table</c><00:01:13.190><c> and</c><00:01:13.370><c> then</c><00:01:13.880><c> it</c><00:01:14.000><c> uses</c>

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

00:01:14.180 --> 00:01:15.999 align:start position:0%
the customers table and then it uses
this<00:01:14.600><c> list</c><00:01:14.869><c> to</c><00:01:15.020><c> get</c><00:01:15.110><c> all</c><00:01:15.350><c> of</c><00:01:15.500><c> the</c><00:01:15.619><c> orders</c><00:01:15.979><c> that</c>

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

00:01:16.009 --> 00:01:18.550 align:start position:0%
this list to get all of the orders that
are<00:01:16.159><c> connected</c><00:01:16.640><c> with</c><00:01:16.789><c> a</c><00:01:16.820><c> customer</c><00:01:17.350><c> that</c><00:01:18.350><c> means</c>

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

00:01:18.560 --> 00:01:20.560 align:start position:0%
are connected with a customer that means
the<00:01:18.710><c> query</c><00:01:18.979><c> is</c><00:01:19.159><c> going</c><00:01:19.399><c> to</c><00:01:19.520><c> include</c><00:01:19.820><c> all</c><00:01:20.090><c> of</c><00:01:20.450><c> the</c>

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

00:01:20.570 --> 00:01:22.300 align:start position:0%
the query is going to include all of the
customer<00:01:20.990><c> records</c><00:01:21.380><c> even</c><00:01:21.920><c> if</c><00:01:22.009><c> they're</c><00:01:22.159><c> not</c>

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

00:01:22.310 --> 00:01:24.069 align:start position:0%
customer records even if they're not
connected<00:01:22.700><c> with</c><00:01:22.729><c> an</c><00:01:22.939><c> order</c><00:01:23.240><c> and</c><00:01:23.390><c> this</c><00:01:23.750><c> is</c><00:01:23.930><c> not</c>

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

00:01:24.079 --> 00:01:27.279 align:start position:0%
connected with an order and this is not
what<00:01:24.289><c> we</c><00:01:24.439><c> want</c><00:01:25.329><c> instead</c><00:01:26.329><c> we</c><00:01:26.630><c> want</c><00:01:26.810><c> to</c><00:01:26.869><c> use</c><00:01:26.960><c> the</c>

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

00:01:27.289 --> 00:01:29.230 align:start position:0%
what we want instead we want to use the
order<00:01:27.500><c> records</c><00:01:28.039><c> to</c><00:01:28.250><c> just</c><00:01:28.609><c> pull</c><00:01:28.880><c> in</c><00:01:29.119><c> the</c>

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

00:01:29.240 --> 00:01:31.300 align:start position:0%
order records to just pull in the
customers<00:01:29.689><c> who</c><00:01:29.810><c> have</c><00:01:29.899><c> placed</c><00:01:30.049><c> an</c><00:01:30.320><c> order</c><00:01:30.439><c> we</c>

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

00:01:31.310 --> 00:01:33.219 align:start position:0%
customers who have placed an order we
can<00:01:31.460><c> do</c><00:01:31.579><c> this</c><00:01:31.729><c> by</c><00:01:31.909><c> choosing</c><00:01:32.210><c> a</c><00:01:32.539><c> right-to-left</c>

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

00:01:33.229 --> 00:01:36.399 align:start position:0%
can do this by choosing a right-to-left
join<00:01:33.909><c> now</c><00:01:34.909><c> the</c><00:01:34.969><c> query</c><00:01:35.450><c> will</c><00:01:35.659><c> first</c><00:01:35.960><c> retrieve</c>

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

00:01:36.409 --> 00:01:38.080 align:start position:0%
join now the query will first retrieve
all<00:01:36.649><c> of</c><00:01:36.799><c> the</c><00:01:36.890><c> records</c><00:01:37.219><c> from</c><00:01:37.369><c> the</c><00:01:37.460><c> orders</c><00:01:37.579><c> table</c>

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

00:01:38.090 --> 00:01:40.480 align:start position:0%
all of the records from the orders table
and<00:01:38.899><c> it</c><00:01:39.049><c> will</c><00:01:39.170><c> then</c><00:01:39.289><c> use</c><00:01:39.500><c> that</c><00:01:39.799><c> list</c><00:01:40.070><c> to</c><00:01:40.250><c> find</c>

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

00:01:40.490 --> 00:01:42.249 align:start position:0%
and it will then use that list to find
all<00:01:40.729><c> of</c><00:01:40.880><c> the</c><00:01:41.000><c> customers</c><00:01:41.450><c> who</c><00:01:41.479><c> are</c><00:01:41.600><c> connected</c>

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

00:01:42.259 --> 00:01:46.040 align:start position:0%
all of the customers who are connected
with<00:01:42.289><c> at</c><00:01:42.590><c> least</c><00:01:42.740><c> one</c><00:01:43.039><c> order</c>

00:01:46.040 --> 00:01:46.050 align:start position:0%
 
 

00:01:46.050 --> 00:01:48.450 align:start position:0%
 
so<00:01:47.050><c> whenever</c><00:01:47.260><c> you're</c><00:01:47.530><c> creating</c><00:01:47.950><c> a</c><00:01:48.010><c> query</c><00:01:48.220><c> with</c>

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

00:01:48.460 --> 00:01:50.430 align:start position:0%
so whenever you're creating a query with
multiple<00:01:48.880><c> tables</c><00:01:49.120><c> you'll</c><00:01:49.780><c> need</c><00:01:50.020><c> to</c><00:01:50.170><c> decide</c>

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

00:01:50.440 --> 00:01:53.250 align:start position:0%
multiple tables you'll need to decide
which<00:01:50.680><c> type</c><00:01:50.950><c> of</c><00:01:51.010><c> join</c><00:01:51.160><c> to</c><00:01:51.490><c> use</c><00:01:51.810><c> you</c><00:01:52.810><c> can</c><00:01:52.960><c> double</c>

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

00:01:53.260 --> 00:01:55.770 align:start position:0%
which type of join to use you can double
click<00:01:53.440><c> the</c><00:01:53.590><c> join</c><00:01:53.740><c> to</c><00:01:53.950><c> change</c><00:01:54.220><c> it</c><00:01:54.370><c> and</c><00:01:54.780><c> then</c>

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

00:01:55.780 --> 00:01:57.840 align:start position:0%
click the join to change it and then
choose<00:01:56.140><c> option</c><00:01:56.770><c> two</c><00:01:57.040><c> for</c><00:01:57.430><c> a</c><00:01:57.460><c> left-to-right</c>

00:01:57.840 --> 00:01:57.850 align:start position:0%
choose option two for a left-to-right
 

00:01:57.850 --> 00:02:00.990 align:start position:0%
choose option two for a left-to-right
join<00:01:58.330><c> or</c><00:01:59.110><c> option</c><00:01:59.800><c> 3</c><00:02:00.160><c> for</c><00:02:00.460><c> a</c><00:02:00.490><c> right-to-left</c>

00:02:00.990 --> 00:02:01.000 align:start position:0%
join or option 3 for a right-to-left
 

00:02:01.000 --> 00:02:07.170 align:start position:0%
join or option 3 for a right-to-left
join<00:02:04.890><c> we</c><00:02:05.890><c> are</c><00:02:06.010><c> also</c><00:02:06.220><c> narrowing</c><00:02:06.850><c> down</c><00:02:06.880><c> our</c>

00:02:07.170 --> 00:02:07.180 align:start position:0%
join we are also narrowing down our
 

00:02:07.180 --> 00:02:09.330 align:start position:0%
join we are also narrowing down our
query<00:02:07.420><c> by</c><00:02:07.630><c> using</c><00:02:07.869><c> search</c><00:02:08.289><c> criteria</c><00:02:08.920><c> in</c><00:02:09.100><c> the</c>

00:02:09.330 --> 00:02:09.340 align:start position:0%
query by using search criteria in the
 

00:02:09.340 --> 00:02:11.760 align:start position:0%
query by using search criteria in the
city<00:02:09.580><c> and</c><00:02:09.850><c> phone</c><00:02:10.119><c> number</c><00:02:10.420><c> fields</c><00:02:10.810><c> you</c><00:02:11.650><c> may</c>

00:02:11.760 --> 00:02:11.770 align:start position:0%
city and phone number fields you may
 

00:02:11.770 --> 00:02:13.440 align:start position:0%
city and phone number fields you may
remember<00:02:12.010><c> that</c><00:02:12.160><c> search</c><00:02:12.459><c> criteria</c><00:02:12.670><c> have</c><00:02:13.240><c> to</c><00:02:13.270><c> be</c>

00:02:13.440 --> 00:02:13.450 align:start position:0%
remember that search criteria have to be
 

00:02:13.450 --> 00:02:15.630 align:start position:0%
remember that search criteria have to be
written<00:02:13.720><c> with</c><00:02:13.840><c> a</c><00:02:13.990><c> very</c><00:02:14.320><c> specific</c><00:02:14.590><c> syntax</c><00:02:15.160><c> so</c>

00:02:15.630 --> 00:02:15.640 align:start position:0%
written with a very specific syntax so
 

00:02:15.640 --> 00:02:17.100 align:start position:0%
written with a very specific syntax so
that<00:02:15.790><c> access</c><00:02:16.150><c> can</c><00:02:16.300><c> understand</c><00:02:16.780><c> them</c><00:02:16.930><c> and</c>

00:02:17.100 --> 00:02:17.110 align:start position:0%
that access can understand them and
 

00:02:17.110 --> 00:02:19.260 align:start position:0%
that access can understand them and
they'll<00:02:17.620><c> often</c><00:02:17.830><c> need</c><00:02:18.220><c> to</c><00:02:18.250><c> include</c><00:02:18.610><c> quotation</c>

00:02:19.260 --> 00:02:19.270 align:start position:0%
they'll often need to include quotation
 

00:02:19.270 --> 00:02:20.970 align:start position:0%
they'll often need to include quotation
marks<00:02:19.570><c> and</c><00:02:19.840><c> parentheses</c><00:02:20.410><c> in</c><00:02:20.590><c> order</c><00:02:20.770><c> to</c><00:02:20.860><c> be</c>

00:02:20.970 --> 00:02:20.980 align:start position:0%
marks and parentheses in order to be
 

00:02:20.980 --> 00:02:23.250 align:start position:0%
marks and parentheses in order to be
correct<00:02:21.310><c> so</c><00:02:22.270><c> let's</c><00:02:22.480><c> look</c><00:02:22.600><c> at</c><00:02:22.750><c> a</c><00:02:22.780><c> few</c><00:02:23.050><c> of</c><00:02:23.170><c> the</c>

00:02:23.250 --> 00:02:23.260 align:start position:0%
correct so let's look at a few of the
 

00:02:23.260 --> 00:02:26.840 align:start position:0%
correct so let's look at a few of the
different<00:02:23.590><c> syntaxes</c><00:02:24.070><c> that</c><00:02:24.250><c> you</c><00:02:24.340><c> can</c><00:02:24.520><c> use</c><00:02:24.790><c> if</c>

00:02:26.840 --> 00:02:26.850 align:start position:0%
different syntaxes that you can use if
 

00:02:26.850 --> 00:02:29.760 align:start position:0%
different syntaxes that you can use if
you're<00:02:27.850><c> looking</c><00:02:28.180><c> for</c><00:02:28.420><c> an</c><00:02:28.540><c> exact</c><00:02:28.930><c> match</c><00:02:29.200><c> then</c>

00:02:29.760 --> 00:02:29.770 align:start position:0%
you're looking for an exact match then
 

00:02:29.770 --> 00:02:31.380 align:start position:0%
you're looking for an exact match then
you<00:02:29.950><c> can</c><00:02:30.100><c> just</c><00:02:30.220><c> put</c><00:02:30.430><c> your</c><00:02:30.550><c> search</c><00:02:30.790><c> terms</c><00:02:31.150><c> in</c>

00:02:31.380 --> 00:02:31.390 align:start position:0%
you can just put your search terms in
 

00:02:31.390 --> 00:02:34.800 align:start position:0%
you can just put your search terms in
quotation<00:02:31.900><c> marks</c><00:02:31.930><c> if</c><00:02:33.060><c> you</c><00:02:34.060><c> want</c><00:02:34.270><c> to</c><00:02:34.420><c> exclude</c>

00:02:34.800 --> 00:02:34.810 align:start position:0%
quotation marks if you want to exclude
 

00:02:34.810 --> 00:02:36.810 align:start position:0%
quotation marks if you want to exclude
something<00:02:35.350><c> from</c><00:02:35.709><c> the</c><00:02:35.800><c> results</c><00:02:36.190><c> then</c><00:02:36.550><c> you</c><00:02:36.670><c> can</c>

00:02:36.810 --> 00:02:36.820 align:start position:0%
something from the results then you can
 

00:02:36.820 --> 00:02:39.570 align:start position:0%
something from the results then you can
use<00:02:37.090><c> not</c><00:02:37.540><c> in</c><00:02:37.810><c> and</c><00:02:38.200><c> you</c><00:02:38.830><c> can</c><00:02:38.950><c> even</c><00:02:38.980><c> exclude</c>

00:02:39.570 --> 00:02:39.580 align:start position:0%
use not in and you can even exclude
 

00:02:39.580 --> 00:02:41.130 align:start position:0%
use not in and you can even exclude
several<00:02:40.000><c> different</c><00:02:40.300><c> things</c><00:02:40.420><c> by</c><00:02:40.690><c> separating</c>

00:02:41.130 --> 00:02:41.140 align:start position:0%
several different things by separating
 

00:02:41.140 --> 00:02:45.420 align:start position:0%
several different things by separating
them<00:02:41.350><c> with</c><00:02:41.410><c> commas</c><00:02:41.760><c> if</c><00:02:43.980><c> you're</c><00:02:44.980><c> looking</c><00:02:45.250><c> for</c>

00:02:45.420 --> 00:02:45.430 align:start position:0%
them with commas if you're looking for
 

00:02:45.430 --> 00:02:47.250 align:start position:0%
them with commas if you're looking for
terms<00:02:45.640><c> at</c><00:02:45.910><c> the</c><00:02:45.970><c> beginning</c><00:02:46.510><c> or</c><00:02:46.690><c> the</c><00:02:46.720><c> end</c><00:02:47.020><c> of</c><00:02:47.170><c> a</c>

00:02:47.250 --> 00:02:47.260 align:start position:0%
terms at the beginning or the end of a
 

00:02:47.260 --> 00:02:49.380 align:start position:0%
terms at the beginning or the end of a
field<00:02:47.470><c> you'll</c><00:02:47.950><c> need</c><00:02:48.130><c> to</c><00:02:48.280><c> use</c><00:02:48.310><c> the</c><00:02:48.520><c> like</c><00:02:48.970><c> syntax</c>

00:02:49.380 --> 00:02:49.390 align:start position:0%
field you'll need to use the like syntax
 

00:02:49.390 --> 00:02:51.570 align:start position:0%
field you'll need to use the like syntax
and<00:02:49.900><c> you'll</c><00:02:50.380><c> notice</c><00:02:50.560><c> that</c><00:02:50.680><c> each</c><00:02:51.040><c> one</c><00:02:51.070><c> of</c><00:02:51.370><c> these</c>

00:02:51.570 --> 00:02:51.580 align:start position:0%
and you'll notice that each one of these
 

00:02:51.580 --> 00:02:54.600 align:start position:0%
and you'll notice that each one of these
has<00:02:51.910><c> an</c><00:02:52.180><c> asterisk</c><00:02:52.630><c> in</c><00:02:52.900><c> it</c><00:02:53.049><c> this</c><00:02:53.980><c> is</c><00:02:54.040><c> known</c><00:02:54.340><c> as</c><00:02:54.370><c> a</c>

00:02:54.600 --> 00:02:54.610 align:start position:0%
has an asterisk in it this is known as a
 

00:02:54.610 --> 00:02:56.940 align:start position:0%
has an asterisk in it this is known as a
wild-card<00:02:55.360><c> character</c><00:02:55.630><c> which</c><00:02:56.500><c> just</c><00:02:56.769><c> means</c>

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

00:02:56.950 --> 00:02:59.910 align:start position:0%
wild-card character which just means
that<00:02:57.220><c> anything</c><00:02:57.760><c> can</c><00:02:57.970><c> go</c><00:02:58.120><c> here</c><00:02:58.420><c> for</c><00:02:59.350><c> example</c><00:02:59.620><c> if</c>

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

00:02:59.920 --> 00:03:01.140 align:start position:0%
that anything can go here for example if
you're<00:03:00.070><c> looking</c><00:03:00.340><c> for</c><00:03:00.519><c> phone</c><00:03:00.760><c> numbers</c><00:03:01.120><c> that</c>

00:03:01.140 --> 00:03:01.150 align:start position:0%
you're looking for phone numbers that
 

00:03:01.150 --> 00:03:03.330 align:start position:0%
you're looking for phone numbers that
begin<00:03:01.420><c> with</c><00:03:01.840><c> nine</c><00:03:02.110><c> one</c><00:03:02.350><c> nine</c><00:03:02.380><c> then</c><00:03:03.130><c> you'll</c>

00:03:03.330 --> 00:03:03.340 align:start position:0%
begin with nine one nine then you'll
 

00:03:03.340 --> 00:03:06.150 align:start position:0%
begin with nine one nine then you'll
type<00:03:03.549><c> nine</c><00:03:04.000><c> one</c><00:03:04.269><c> nine</c><00:03:04.350><c> asterisk</c><00:03:05.350><c> and</c><00:03:05.560><c> that</c>

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

00:03:06.160 --> 00:03:07.770 align:start position:0%
type nine one nine asterisk and that
means<00:03:06.370><c> this</c><00:03:06.519><c> query</c><00:03:06.820><c> will</c><00:03:07.000><c> look</c><00:03:07.150><c> for</c><00:03:07.330><c> nine</c><00:03:07.540><c> one</c>

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

00:03:07.780 --> 00:03:10.410 align:start position:0%
means this query will look for nine one
nine<00:03:07.810><c> followed</c><00:03:08.709><c> by</c><00:03:08.860><c> anything</c>

00:03:10.410 --> 00:03:10.420 align:start position:0%
nine followed by anything
 

00:03:10.420 --> 00:03:13.530 align:start position:0%
nine followed by anything
and<00:03:11.849><c> finally</c><00:03:12.849><c> when</c><00:03:13.090><c> you're</c><00:03:13.209><c> working</c><00:03:13.510><c> with</c>

00:03:13.530 --> 00:03:13.540 align:start position:0%
and finally when you're working with
 

00:03:13.540 --> 00:03:15.449 align:start position:0%
and finally when you're working with
numbers<00:03:14.110><c> you</c><00:03:14.530><c> can</c><00:03:14.680><c> use</c><00:03:14.709><c> symbols</c><00:03:15.250><c> such</c><00:03:15.430><c> as</c>

00:03:15.449 --> 00:03:15.459 align:start position:0%
numbers you can use symbols such as
 

00:03:15.459 --> 00:03:17.670 align:start position:0%
numbers you can use symbols such as
greater<00:03:15.910><c> than</c><00:03:16.000><c> and</c><00:03:16.450><c> less</c><00:03:16.480><c> than</c><00:03:16.870><c> to</c><00:03:17.290><c> test</c><00:03:17.530><c> the</c>

00:03:17.670 --> 00:03:17.680 align:start position:0%
greater than and less than to test the
 

00:03:17.680 --> 00:03:19.860 align:start position:0%
greater than and less than to test the
values<00:03:18.010><c> and</c><00:03:18.190><c> you</c><00:03:18.819><c> can</c><00:03:18.970><c> also</c><00:03:19.090><c> look</c><00:03:19.390><c> for</c><00:03:19.569><c> numbers</c>

00:03:19.860 --> 00:03:19.870 align:start position:0%
values and you can also look for numbers
 

00:03:19.870 --> 00:03:23.130 align:start position:0%
values and you can also look for numbers
that<00:03:19.900><c> are</c><00:03:20.170><c> between</c><00:03:20.500><c> two</c><00:03:20.709><c> values</c><00:03:20.920><c> so</c><00:03:21.989><c> those</c><00:03:22.989><c> are</c>

00:03:23.130 --> 00:03:23.140 align:start position:0%
that are between two values so those are
 

00:03:23.140 --> 00:03:24.839 align:start position:0%
that are between two values so those are
some<00:03:23.260><c> of</c><00:03:23.319><c> the</c><00:03:23.410><c> most</c><00:03:23.590><c> common</c><00:03:24.069><c> syntaxes</c><00:03:24.700><c> that</c>

00:03:24.839 --> 00:03:24.849 align:start position:0%
some of the most common syntaxes that
 

00:03:24.849 --> 00:03:27.180 align:start position:0%
some of the most common syntaxes that
you<00:03:24.970><c> can</c><00:03:25.120><c> use</c><00:03:25.360><c> and</c><00:03:25.569><c> you</c><00:03:26.080><c> might</c><00:03:26.260><c> not</c><00:03:26.410><c> use</c><00:03:26.650><c> all</c><00:03:26.680><c> of</c>

00:03:27.180 --> 00:03:27.190 align:start position:0%
you can use and you might not use all of
 

00:03:27.190 --> 00:03:28.800 align:start position:0%
you can use and you might not use all of
these<00:03:27.340><c> but</c><00:03:27.819><c> depending</c><00:03:28.270><c> on</c><00:03:28.360><c> what</c><00:03:28.420><c> type</c><00:03:28.780><c> of</c>

00:03:28.800 --> 00:03:28.810 align:start position:0%
these but depending on what type of
 

00:03:28.810 --> 00:03:30.210 align:start position:0%
these but depending on what type of
information<00:03:29.200><c> you</c><00:03:29.560><c> have</c><00:03:29.770><c> in</c><00:03:29.920><c> your</c><00:03:30.040><c> database</c>

00:03:30.210 --> 00:03:30.220 align:start position:0%
information you have in your database
 

00:03:30.220 --> 00:03:32.520 align:start position:0%
information you have in your database
you<00:03:30.910><c> can</c><00:03:31.000><c> probably</c><00:03:31.239><c> find</c><00:03:31.660><c> at</c><00:03:31.930><c> least</c><00:03:32.140><c> two</c><00:03:32.410><c> or</c>

00:03:32.520 --> 00:03:32.530 align:start position:0%
you can probably find at least two or
 

00:03:32.530 --> 00:03:35.880 align:start position:0%
you can probably find at least two or
three<00:03:32.590><c> that</c><00:03:32.920><c> will</c><00:03:32.980><c> be</c><00:03:33.040><c> useful</c><00:03:33.550><c> to</c><00:03:33.730><c> you</c>