WEBVTT
Kind: captions
Language: en

00:00:01.830 --> 00:00:09.520 align:start position:0%
 
[Music]

00:00:09.520 --> 00:00:09.530 align:start position:0%
 
 

00:00:09.530 --> 00:00:13.669 align:start position:0%
 
in<00:00:11.209><c> the</c><00:00:12.209><c> last</c><00:00:12.360><c> video</c><00:00:12.690><c> we</c><00:00:12.929><c> created</c><00:00:13.080><c> a</c><00:00:13.410><c> query</c>

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

00:00:13.679 --> 00:00:16.189 align:start position:0%
in the last video we created a query
that<00:00:13.740><c> used</c><00:00:14.070><c> two</c><00:00:14.459><c> tables</c><00:00:14.910><c> and</c><00:00:15.119><c> we</c><00:00:15.599><c> just</c><00:00:15.900><c> wanted</c>

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

00:00:16.199 --> 00:00:17.929 align:start position:0%
that used two tables and we just wanted
our<00:00:16.320><c> query</c><00:00:16.590><c> to</c><00:00:16.770><c> include</c><00:00:17.099><c> customers</c><00:00:17.669><c> who</c><00:00:17.820><c> have</c>

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

00:00:17.939 --> 00:00:20.600 align:start position:0%
our query to include customers who have
placed<00:00:18.150><c> an</c><00:00:18.450><c> order</c><00:00:18.630><c> at</c><00:00:18.810><c> our</c><00:00:18.960><c> bakery</c><00:00:19.460><c> now</c><00:00:20.460><c> we're</c>

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

00:00:20.610 --> 00:00:22.370 align:start position:0%
placed an order at our bakery now we're
going<00:00:20.789><c> to</c><00:00:20.880><c> talk</c><00:00:21.119><c> about</c><00:00:21.300><c> why</c><00:00:21.750><c> we</c><00:00:21.990><c> chose</c><00:00:22.020><c> the</c>

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

00:00:22.380 --> 00:00:24.140 align:start position:0%
going to talk about why we chose the
type<00:00:22.529><c> of</c><00:00:22.680><c> join</c><00:00:22.919><c> that</c><00:00:23.070><c> we</c><00:00:23.160><c> did</c><00:00:23.369><c> and</c><00:00:23.579><c> we're</c><00:00:24.000><c> also</c>

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

00:00:24.150 --> 00:00:25.940 align:start position:0%
type of join that we did and we're also
going<00:00:24.480><c> to</c><00:00:24.570><c> look</c><00:00:24.720><c> at</c><00:00:24.810><c> some</c><00:00:24.990><c> examples</c><00:00:25.439><c> of</c><00:00:25.619><c> search</c>

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

00:00:25.950 --> 00:00:27.709 align:start position:0%
going to look at some examples of search
criteria<00:00:26.160><c> that</c><00:00:26.730><c> you</c><00:00:26.820><c> can</c><00:00:26.969><c> use</c><00:00:27.119><c> to</c><00:00:27.300><c> narrow</c><00:00:27.540><c> down</c>

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

00:00:27.719 --> 00:00:30.530 align:start position:0%
criteria that you can use to narrow down
your<00:00:27.930><c> queries</c><00:00:28.259><c> in</c><00:00:28.669><c> this</c><00:00:29.669><c> example</c><00:00:30.000><c> we</c><00:00:30.239><c> chose</c><00:00:30.509><c> a</c>

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

00:00:30.540 --> 00:00:32.600 align:start position:0%
your queries in this example we chose a
left<00:00:30.960><c> join</c><00:00:31.290><c> because</c><00:00:31.529><c> we</c><00:00:31.800><c> wanted</c><00:00:32.040><c> the</c><00:00:32.099><c> query</c><00:00:32.399><c> to</c>

00:00:32.600 --> 00:00:32.610 align:start position:0%
left join because we wanted the query to
 

00:00:32.610 --> 00:00:34.040 align:start position:0%
left join because we wanted the query to
pull<00:00:32.790><c> in</c><00:00:32.940><c> the</c><00:00:33.030><c> records</c><00:00:33.360><c> from</c><00:00:33.510><c> the</c><00:00:33.600><c> orders</c>

00:00:34.040 --> 00:00:34.050 align:start position:0%
pull in the records from the orders
 

00:00:34.050 --> 00:00:36.380 align:start position:0%
pull in the records from the orders
table<00:00:34.230><c> first</c><00:00:34.620><c> and</c><00:00:34.950><c> then</c><00:00:35.520><c> use</c><00:00:35.700><c> the</c><00:00:35.879><c> information</c>

00:00:36.380 --> 00:00:36.390 align:start position:0%
table first and then use the information
 

00:00:36.390 --> 00:00:38.330 align:start position:0%
table first and then use the information
in<00:00:36.570><c> those</c><00:00:36.750><c> records</c><00:00:37.260><c> to</c><00:00:37.350><c> retrieve</c><00:00:37.800><c> the</c><00:00:38.010><c> records</c>

00:00:38.330 --> 00:00:38.340 align:start position:0%
in those records to retrieve the records
 

00:00:38.340 --> 00:00:40.670 align:start position:0%
in those records to retrieve the records
from<00:00:38.489><c> the</c><00:00:38.579><c> customers</c><00:00:39.120><c> table</c><00:00:39.329><c> to</c><00:00:40.230><c> understand</c>

00:00:40.670 --> 00:00:40.680 align:start position:0%
from the customers table to understand
 

00:00:40.680 --> 00:00:42.290 align:start position:0%
from the customers table to understand
how<00:00:40.829><c> this</c><00:00:40.980><c> works</c><00:00:41.039><c> let's</c><00:00:41.730><c> look</c><00:00:41.820><c> at</c><00:00:42.000><c> how</c><00:00:42.120><c> these</c>

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

00:00:42.300 --> 00:00:44.840 align:start position:0%
how this works let's look at how these
tables<00:00:42.690><c> are</c><00:00:42.810><c> connected</c><00:00:43.370><c> every</c><00:00:44.370><c> time</c><00:00:44.579><c> an</c><00:00:44.730><c> order</c>

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

00:00:44.850 --> 00:00:46.880 align:start position:0%
tables are connected every time an order
is<00:00:45.090><c> placed</c><00:00:45.180><c> it's</c><00:00:45.750><c> connected</c><00:00:46.200><c> with</c><00:00:46.320><c> a</c><00:00:46.350><c> customer</c>

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

00:00:46.890 --> 00:00:48.950 align:start position:0%
is placed it's connected with a customer
and<00:00:47.070><c> if</c><00:00:47.579><c> someone</c><00:00:47.850><c> places</c><00:00:48.090><c> multiple</c><00:00:48.630><c> orders</c>

00:00:48.950 --> 00:00:48.960 align:start position:0%
and if someone places multiple orders
 

00:00:48.960 --> 00:00:50.360 align:start position:0%
and if someone places multiple orders
then<00:00:49.200><c> they'll</c><00:00:49.320><c> be</c><00:00:49.410><c> connected</c><00:00:49.800><c> with</c><00:00:49.950><c> each</c><00:00:50.130><c> of</c>

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

00:00:50.370 --> 00:00:52.910 align:start position:0%
then they'll be connected with each of
those<00:00:50.489><c> orders</c><00:00:50.940><c> you'll</c><00:00:51.900><c> notice</c><00:00:52.200><c> that</c><00:00:52.350><c> not</c><00:00:52.650><c> all</c>

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

00:00:52.920 --> 00:00:54.410 align:start position:0%
those orders you'll notice that not all
of<00:00:52.950><c> our</c><00:00:53.160><c> customers</c><00:00:53.640><c> have</c><00:00:53.820><c> placed</c><00:00:54.090><c> an</c><00:00:54.270><c> order</c>

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

00:00:54.420 --> 00:00:56.870 align:start position:0%
of our customers have placed an order
but<00:00:55.140><c> all</c><00:00:55.410><c> of</c><00:00:55.590><c> the</c><00:00:55.739><c> orders</c><00:00:56.130><c> are</c><00:00:56.310><c> connected</c><00:00:56.730><c> with</c>

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

00:00:56.880 --> 00:00:58.910 align:start position:0%
but all of the orders are connected with
a<00:00:56.910><c> customer</c><00:00:57.450><c> and</c><00:00:57.630><c> that's</c><00:00:58.200><c> an</c><00:00:58.410><c> important</c><00:00:58.890><c> thing</c>

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

00:00:58.920 --> 00:01:00.380 align:start position:0%
a customer and that's an important thing
to<00:00:59.160><c> keep</c><00:00:59.310><c> in</c><00:00:59.460><c> mind</c><00:00:59.520><c> when</c><00:00:59.850><c> we're</c><00:01:00.000><c> choosing</c>

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

00:01:00.390 --> 00:01:03.200 align:start position:0%
to keep in mind when we're choosing
which<00:01:00.570><c> type</c><00:01:00.809><c> of</c><00:01:00.870><c> join</c><00:01:01.050><c> to</c><00:01:01.410><c> use</c><00:01:01.910><c> let's</c><00:01:02.910><c> look</c><00:01:03.090><c> at</c>

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

00:01:03.210 --> 00:01:04.759 align:start position:0%
which type of join to use let's look at
what<00:01:03.420><c> would</c><00:01:03.570><c> happen</c><00:01:03.899><c> if</c><00:01:04.049><c> we</c><00:01:04.199><c> connected</c><00:01:04.619><c> these</c>

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

00:01:04.769 --> 00:01:07.609 align:start position:0%
what would happen if we connected these
tables<00:01:05.159><c> with</c><00:01:05.369><c> a</c><00:01:05.399><c> right</c><00:01:05.729><c> join</c><00:01:06.020><c> first</c><00:01:07.020><c> access</c>

00:01:07.609 --> 00:01:07.619 align:start position:0%
tables with a right join first access
 

00:01:07.619 --> 00:01:09.380 align:start position:0%
tables with a right join first access
retrieves<00:01:08.130><c> all</c><00:01:08.369><c> of</c><00:01:08.610><c> the</c><00:01:08.729><c> records</c><00:01:09.060><c> from</c><00:01:09.210><c> the</c>

00:01:09.380 --> 00:01:09.390 align:start position:0%
retrieves all of the records from the
 

00:01:09.390 --> 00:01:11.600 align:start position:0%
retrieves all of the records from the
customers<00:01:09.869><c> table</c><00:01:10.049><c> and</c><00:01:10.380><c> then</c><00:01:10.890><c> it</c><00:01:11.009><c> uses</c><00:01:11.189><c> this</c>

00:01:11.600 --> 00:01:11.610 align:start position:0%
customers table and then it uses this
 

00:01:11.610 --> 00:01:13.190 align:start position:0%
customers table and then it uses this
list<00:01:11.880><c> to</c><00:01:12.030><c> get</c><00:01:12.149><c> all</c><00:01:12.360><c> of</c><00:01:12.509><c> the</c><00:01:12.630><c> orders</c><00:01:12.990><c> that</c><00:01:13.020><c> are</c>

00:01:13.190 --> 00:01:13.200 align:start position:0%
list to get all of the orders that are
 

00:01:13.200 --> 00:01:15.590 align:start position:0%
list to get all of the orders that are
connected<00:01:13.650><c> with</c><00:01:13.680><c> a</c><00:01:13.830><c> customer</c><00:01:14.340><c> that</c><00:01:15.240><c> means</c><00:01:15.450><c> the</c>

00:01:15.590 --> 00:01:15.600 align:start position:0%
connected with a customer that means the
 

00:01:15.600 --> 00:01:17.450 align:start position:0%
connected with a customer that means the
query<00:01:15.870><c> is</c><00:01:16.049><c> going</c><00:01:16.290><c> to</c><00:01:16.409><c> include</c><00:01:16.710><c> all</c><00:01:16.979><c> of</c><00:01:17.340><c> the</c>

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

00:01:17.460 --> 00:01:19.160 align:start position:0%
query is going to include all of the
customer<00:01:17.880><c> records</c><00:01:18.270><c> even</c><00:01:18.659><c> if</c><00:01:18.900><c> they're</c><00:01:19.049><c> not</c>

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

00:01:19.170 --> 00:01:20.960 align:start position:0%
customer records even if they're not
connected<00:01:19.590><c> with</c><00:01:19.620><c> an</c><00:01:19.830><c> order</c><00:01:20.130><c> and</c><00:01:20.280><c> this</c><00:01:20.640><c> is</c><00:01:20.820><c> not</c>

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

00:01:20.970 --> 00:01:23.510 align:start position:0%
connected with an order and this is not
what<00:01:21.180><c> we</c><00:01:21.330><c> want</c><00:01:21.570><c> instead</c><00:01:22.500><c> we</c><00:01:22.830><c> want</c><00:01:23.040><c> to</c><00:01:23.100><c> use</c><00:01:23.159><c> the</c>

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

00:01:23.520 --> 00:01:25.490 align:start position:0%
what we want instead we want to use the
order<00:01:23.729><c> records</c><00:01:24.270><c> to</c><00:01:24.479><c> just</c><00:01:24.869><c> pull</c><00:01:25.140><c> in</c><00:01:25.350><c> the</c>

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

00:01:25.500 --> 00:01:27.560 align:start position:0%
order records to just pull in the
customers<00:01:25.920><c> who</c><00:01:26.040><c> have</c><00:01:26.159><c> placed</c><00:01:26.310><c> an</c><00:01:26.580><c> order</c><00:01:26.700><c> we</c>

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

00:01:27.570 --> 00:01:30.590 align:start position:0%
customers who have placed an order we
can<00:01:27.690><c> do</c><00:01:27.840><c> this</c><00:01:27.990><c> by</c><00:01:28.170><c> choosing</c><00:01:28.409><c> a</c><00:01:28.710><c> left</c><00:01:29.040><c> join</c><00:01:29.600><c> now</c>

00:01:30.590 --> 00:01:30.600 align:start position:0%
can do this by choosing a left join now
 

00:01:30.600 --> 00:01:32.600 align:start position:0%
can do this by choosing a left join now
the<00:01:30.659><c> query</c><00:01:31.110><c> will</c><00:01:31.350><c> first</c><00:01:31.650><c> retrieve</c><00:01:32.130><c> all</c><00:01:32.369><c> of</c><00:01:32.490><c> the</c>

00:01:32.600 --> 00:01:32.610 align:start position:0%
the query will first retrieve all of the
 

00:01:32.610 --> 00:01:34.760 align:start position:0%
the query will first retrieve all of the
records<00:01:32.909><c> from</c><00:01:33.060><c> the</c><00:01:33.150><c> orders</c><00:01:33.270><c> table</c><00:01:33.780><c> and</c><00:01:34.110><c> it</c>

00:01:34.760 --> 00:01:34.770 align:start position:0%
records from the orders table and it
 

00:01:34.770 --> 00:01:36.440 align:start position:0%
records from the orders table and it
will<00:01:34.890><c> then</c><00:01:35.010><c> use</c><00:01:35.220><c> that</c><00:01:35.490><c> list</c><00:01:35.760><c> to</c><00:01:35.970><c> find</c><00:01:36.210><c> all</c><00:01:36.420><c> of</c>

00:01:36.440 --> 00:01:36.450 align:start position:0%
will then use that list to find all of
 

00:01:36.450 --> 00:01:38.270 align:start position:0%
will then use that list to find all of
the<00:01:36.690><c> customers</c><00:01:37.140><c> who</c><00:01:37.170><c> are</c><00:01:37.409><c> connected</c><00:01:37.979><c> with</c><00:01:38.130><c> at</c>

00:01:38.270 --> 00:01:38.280 align:start position:0%
the customers who are connected with at
 

00:01:38.280 --> 00:01:41.370 align:start position:0%
the customers who are connected with at
least<00:01:38.430><c> one</c><00:01:38.729><c> order</c>

00:01:41.370 --> 00:01:41.380 align:start position:0%
 
 

00:01:41.380 --> 00:01:43.109 align:start position:0%
 
so<00:01:41.770><c> whenever</c><00:01:41.950><c> you're</c><00:01:42.250><c> creating</c><00:01:42.670><c> a</c><00:01:42.729><c> query</c><00:01:42.909><c> with</c>

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

00:01:43.119 --> 00:01:44.850 align:start position:0%
so whenever you're creating a query with
multiple<00:01:43.540><c> tables</c><00:01:43.689><c> you'll</c><00:01:44.229><c> need</c><00:01:44.470><c> to</c><00:01:44.590><c> decide</c>

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

00:01:44.860 --> 00:01:47.580 align:start position:0%
multiple tables you'll need to decide
which<00:01:45.130><c> type</c><00:01:45.369><c> of</c><00:01:45.430><c> join</c><00:01:45.580><c> to</c><00:01:45.939><c> use</c><00:01:46.180><c> you</c><00:01:47.140><c> can</c><00:01:47.320><c> double</c>

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

00:01:47.590 --> 00:01:49.499 align:start position:0%
which type of join to use you can double
click<00:01:47.619><c> the</c><00:01:47.920><c> join</c><00:01:48.100><c> to</c><00:01:48.280><c> change</c><00:01:48.549><c> it</c><00:01:48.700><c> and</c><00:01:48.820><c> then</c>

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

00:01:49.509 --> 00:01:52.320 align:start position:0%
click the join to change it and then
choose<00:01:49.869><c> option</c><00:01:50.500><c> two</c><00:01:50.740><c> for</c><00:01:51.159><c> a</c><00:01:51.190><c> right</c><00:01:51.460><c> join</c><00:01:51.759><c> or</c>

00:01:52.320 --> 00:01:52.330 align:start position:0%
choose option two for a right join or
 

00:01:52.330 --> 00:01:56.359 align:start position:0%
choose option two for a right join or
option<00:01:52.990><c> 3</c><00:01:53.320><c> for</c><00:01:53.619><c> a</c><00:01:53.650><c> left</c><00:01:53.950><c> join</c>

00:01:56.359 --> 00:01:56.369 align:start position:0%
 
 

00:01:56.369 --> 00:01:58.730 align:start position:0%
 
we<00:01:56.969><c> are</c><00:01:57.119><c> also</c><00:01:57.299><c> narrowing</c><00:01:57.960><c> down</c><00:01:57.990><c> our</c><00:01:58.140><c> query</c><00:01:58.530><c> by</c>

00:01:58.730 --> 00:01:58.740 align:start position:0%
we are also narrowing down our query by
 

00:01:58.740 --> 00:02:00.950 align:start position:0%
we are also narrowing down our query by
using<00:01:58.770><c> search</c><00:01:59.369><c> criteria</c><00:02:00.000><c> in</c><00:02:00.060><c> the</c><00:02:00.420><c> city</c><00:02:00.689><c> and</c>

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

00:02:00.960 --> 00:02:03.020 align:start position:0%
using search criteria in the city and
phone<00:02:01.229><c> number</c><00:02:01.530><c> fields</c><00:02:01.890><c> you</c><00:02:02.640><c> may</c><00:02:02.789><c> remember</c>

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

00:02:03.030 --> 00:02:04.700 align:start position:0%
phone number fields you may remember
that<00:02:03.270><c> search</c><00:02:03.479><c> criteria</c><00:02:03.689><c> have</c><00:02:04.229><c> to</c><00:02:04.259><c> be</c><00:02:04.500><c> written</c>

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

00:02:04.710 --> 00:02:06.800 align:start position:0%
that search criteria have to be written
with<00:02:04.829><c> a</c><00:02:04.979><c> very</c><00:02:05.310><c> specific</c><00:02:05.609><c> syntax</c><00:02:06.179><c> so</c><00:02:06.659><c> that</c>

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

00:02:06.810 --> 00:02:08.630 align:start position:0%
with a very specific syntax so that
access<00:02:07.140><c> can</c><00:02:07.350><c> understand</c><00:02:07.799><c> them</c><00:02:07.950><c> and</c><00:02:08.099><c> they'll</c>

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

00:02:08.640 --> 00:02:10.580 align:start position:0%
access can understand them and they'll
often<00:02:09.060><c> need</c><00:02:09.209><c> to</c><00:02:09.239><c> include</c><00:02:09.720><c> quotation</c><00:02:10.289><c> marks</c>

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

00:02:10.590 --> 00:02:12.320 align:start position:0%
often need to include quotation marks
and<00:02:10.830><c> parentheses</c><00:02:11.430><c> in</c><00:02:11.610><c> order</c><00:02:11.790><c> to</c><00:02:11.879><c> be</c><00:02:12.000><c> correct</c>

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

00:02:12.330 --> 00:02:14.570 align:start position:0%
and parentheses in order to be correct
so<00:02:13.290><c> let's</c><00:02:13.500><c> look</c><00:02:13.620><c> at</c><00:02:13.739><c> a</c><00:02:13.769><c> few</c><00:02:14.069><c> of</c><00:02:14.160><c> the</c><00:02:14.280><c> different</c>

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

00:02:14.580 --> 00:02:16.970 align:start position:0%
so let's look at a few of the different
syntaxes<00:02:15.090><c> that</c><00:02:15.269><c> you</c><00:02:15.360><c> can</c><00:02:15.540><c> use</c><00:02:15.780><c> if</c><00:02:15.989><c> you're</c>

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

00:02:16.980 --> 00:02:19.220 align:start position:0%
syntaxes that you can use if you're
looking<00:02:17.310><c> for</c><00:02:17.549><c> an</c><00:02:17.700><c> exact</c><00:02:18.090><c> match</c><00:02:18.209><c> then</c><00:02:18.930><c> you</c><00:02:19.110><c> can</c>

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

00:02:19.230 --> 00:02:21.050 align:start position:0%
looking for an exact match then you can
just<00:02:19.379><c> put</c><00:02:19.590><c> your</c><00:02:19.709><c> search</c><00:02:19.950><c> terms</c><00:02:20.310><c> in</c><00:02:20.519><c> quotation</c>

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

00:02:21.060 --> 00:02:24.470 align:start position:0%
just put your search terms in quotation
marks<00:02:21.090><c> if</c><00:02:22.220><c> you</c><00:02:23.220><c> want</c><00:02:23.430><c> to</c><00:02:23.580><c> exclude</c><00:02:24.060><c> something</c>

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

00:02:24.480 --> 00:02:26.960 align:start position:0%
marks if you want to exclude something
from<00:02:24.840><c> the</c><00:02:24.959><c> results</c><00:02:25.349><c> then</c><00:02:25.709><c> you</c><00:02:25.739><c> can</c><00:02:25.980><c> use</c><00:02:26.250><c> not</c><00:02:26.700><c> in</c>

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

00:02:26.970 --> 00:02:29.150 align:start position:0%
from the results then you can use not in
and<00:02:27.360><c> you</c><00:02:27.989><c> can</c><00:02:28.110><c> even</c><00:02:28.260><c> exclude</c><00:02:28.739><c> several</c>

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

00:02:29.160 --> 00:02:30.559 align:start position:0%
and you can even exclude several
different<00:02:29.459><c> things</c><00:02:29.640><c> by</c><00:02:29.849><c> separating</c><00:02:30.299><c> them</c><00:02:30.510><c> with</c>

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

00:02:30.569 --> 00:02:32.760 align:start position:0%
different things by separating them with
commas

00:02:32.760 --> 00:02:32.770 align:start position:0%
 
 

00:02:32.770 --> 00:02:34.530 align:start position:0%
 
if<00:02:32.830><c> you're</c><00:02:33.580><c> looking</c><00:02:33.850><c> for</c><00:02:34.030><c> terms</c><00:02:34.240><c> at</c><00:02:34.510><c> the</c>

00:02:34.530 --> 00:02:34.540 align:start position:0%
if you're looking for terms at the
 

00:02:34.540 --> 00:02:36.540 align:start position:0%
if you're looking for terms at the
beginning<00:02:35.110><c> or</c><00:02:35.290><c> the</c><00:02:35.320><c> end</c><00:02:35.620><c> of</c><00:02:35.770><c> a</c><00:02:35.860><c> field</c><00:02:36.130><c> you'll</c>

00:02:36.540 --> 00:02:36.550 align:start position:0%
beginning or the end of a field you'll
 

00:02:36.550 --> 00:02:39.000 align:start position:0%
beginning or the end of a field you'll
need<00:02:36.730><c> to</c><00:02:36.850><c> use</c><00:02:36.880><c> the</c><00:02:37.300><c> like</c><00:02:37.570><c> syntax</c><00:02:37.990><c> and</c><00:02:38.500><c> you'll</c>

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

00:02:39.010 --> 00:02:40.770 align:start position:0%
need to use the like syntax and you'll
notice<00:02:39.160><c> that</c><00:02:39.280><c> each</c><00:02:39.640><c> one</c><00:02:39.670><c> of</c><00:02:39.970><c> these</c><00:02:40.210><c> has</c><00:02:40.510><c> an</c>

00:02:40.770 --> 00:02:40.780 align:start position:0%
notice that each one of these has an
 

00:02:40.780 --> 00:02:42.990 align:start position:0%
notice that each one of these has an
asterisk<00:02:41.350><c> in</c><00:02:41.500><c> it</c><00:02:41.650><c> this</c><00:02:42.370><c> is</c><00:02:42.430><c> known</c><00:02:42.730><c> as</c><00:02:42.760><c> a</c>

00:02:42.990 --> 00:02:43.000 align:start position:0%
asterisk in it this is known as a
 

00:02:43.000 --> 00:02:45.360 align:start position:0%
asterisk in it this is known as a
wild-card<00:02:43.750><c> character</c><00:02:44.020><c> which</c><00:02:44.920><c> just</c><00:02:45.190><c> means</c>

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

00:02:45.370 --> 00:02:48.330 align:start position:0%
wild-card character which just means
that<00:02:45.490><c> anything</c><00:02:46.180><c> can</c><00:02:46.390><c> go</c><00:02:46.540><c> here</c><00:02:46.840><c> for</c><00:02:47.770><c> example</c><00:02:48.040><c> if</c>

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

00:02:48.340 --> 00:02:49.560 align:start position:0%
that anything can go here for example if
you're<00:02:48.490><c> looking</c><00:02:48.760><c> for</c><00:02:48.940><c> phone</c><00:02:49.180><c> numbers</c><00:02:49.540><c> that</c>

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

00:02:49.570 --> 00:02:51.750 align:start position:0%
you're looking for phone numbers that
begin<00:02:50.080><c> with</c><00:02:50.260><c> nine</c><00:02:50.530><c> one</c><00:02:50.770><c> nine</c><00:02:50.800><c> then</c><00:02:51.550><c> you'll</c>

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

00:02:51.760 --> 00:02:54.600 align:start position:0%
begin with nine one nine then you'll
type<00:02:51.970><c> nine</c><00:02:52.420><c> one</c><00:02:52.690><c> nine</c><00:02:52.770><c> asterisk</c><00:02:53.770><c> and</c><00:02:53.980><c> that</c>

00:02:54.600 --> 00:02:54.610 align:start position:0%
type nine one nine asterisk and that
 

00:02:54.610 --> 00:02:56.190 align:start position:0%
type nine one nine asterisk and that
means<00:02:54.790><c> this</c><00:02:54.970><c> query</c><00:02:55.240><c> will</c><00:02:55.390><c> look</c><00:02:55.570><c> for</c><00:02:55.750><c> nine</c><00:02:55.960><c> one</c>

00:02:56.190 --> 00:02:56.200 align:start position:0%
means this query will look for nine one
 

00:02:56.200 --> 00:02:59.200 align:start position:0%
means this query will look for nine one
nine<00:02:56.230><c> followed</c><00:02:57.130><c> by</c><00:02:57.310><c> anything</c>

00:02:59.200 --> 00:02:59.210 align:start position:0%
nine followed by anything
 

00:02:59.210 --> 00:03:00.940 align:start position:0%
nine followed by anything
and<00:02:59.300><c> finally</c><00:03:00.230><c> when</c><00:03:00.500><c> you're</c><00:03:00.590><c> working</c><00:03:00.920><c> with</c>

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

00:03:00.950 --> 00:03:02.980 align:start position:0%
and finally when you're working with
numbers<00:03:01.310><c> you</c><00:03:01.700><c> can</c><00:03:02.060><c> use</c><00:03:02.090><c> symbols</c><00:03:02.630><c> such</c><00:03:02.810><c> as</c>

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

00:03:02.990 --> 00:03:05.050 align:start position:0%
numbers you can use symbols such as
greater<00:03:03.290><c> than</c><00:03:03.410><c> and</c><00:03:03.860><c> less</c><00:03:03.890><c> than</c><00:03:04.280><c> to</c><00:03:04.700><c> test</c><00:03:04.910><c> the</c>

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

00:03:05.060 --> 00:03:07.030 align:start position:0%
greater than and less than to test the
values<00:03:05.390><c> and</c><00:03:05.570><c> you</c><00:03:06.020><c> can</c><00:03:06.140><c> also</c><00:03:06.290><c> look</c><00:03:06.590><c> for</c><00:03:06.650><c> numbers</c>

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

00:03:07.040 --> 00:03:09.730 align:start position:0%
values and you can also look for numbers
that<00:03:07.220><c> are</c><00:03:07.370><c> between</c><00:03:07.520><c> two</c><00:03:07.910><c> values</c><00:03:08.300><c> so</c><00:03:08.590><c> those</c><00:03:09.590><c> are</c>

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

00:03:09.740 --> 00:03:11.440 align:start position:0%
that are between two values so those are
some<00:03:09.860><c> of</c><00:03:09.920><c> the</c><00:03:10.010><c> most</c><00:03:10.220><c> common</c><00:03:10.670><c> syntaxes</c><00:03:11.300><c> that</c>

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

00:03:11.450 --> 00:03:13.780 align:start position:0%
some of the most common syntaxes that
you<00:03:11.570><c> can</c><00:03:11.720><c> use</c><00:03:11.960><c> and</c><00:03:12.170><c> you</c><00:03:12.680><c> might</c><00:03:12.860><c> not</c><00:03:13.040><c> use</c><00:03:13.250><c> all</c><00:03:13.280><c> of</c>

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

00:03:13.790 --> 00:03:15.400 align:start position:0%
you can use and you might not use all of
these<00:03:13.940><c> but</c><00:03:14.420><c> depending</c><00:03:14.870><c> on</c><00:03:14.960><c> what</c><00:03:15.020><c> type</c><00:03:15.380><c> of</c>

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

00:03:15.410 --> 00:03:16.840 align:start position:0%
these but depending on what type of
information<00:03:15.800><c> you</c><00:03:16.160><c> have</c><00:03:16.370><c> in</c><00:03:16.520><c> your</c><00:03:16.640><c> database</c>

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

00:03:16.850 --> 00:03:19.060 align:start position:0%
information you have in your database
you<00:03:17.420><c> can</c><00:03:17.570><c> probably</c><00:03:17.810><c> find</c><00:03:18.230><c> at</c><00:03:18.470><c> least</c><00:03:18.710><c> two</c><00:03:18.950><c> or</c>

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

00:03:19.070 --> 00:03:23.650 align:start position:0%
you can probably find at least two or
three<00:03:19.130><c> that</c><00:03:19.430><c> will</c><00:03:19.490><c> be</c><00:03:19.550><c> useful</c><00:03:20.060><c> to</c><00:03:20.240><c> you</c><00:03:22.660><c> like</c>

00:03:23.650 --> 00:03:23.660 align:start position:0%
three that will be useful to you like
 

00:03:23.660 --> 00:03:27.130 align:start position:0%
three that will be useful to you like
what<00:03:23.840><c> you</c><00:03:23.990><c> just</c><00:03:24.020><c> saw</c><00:03:25.060><c> radix</c><00:03:26.060><c> add</c><00:03:26.570><c> a</c><00:03:26.630><c> comment</c>

00:03:27.130 --> 00:03:27.140 align:start position:0%
what you just saw radix add a comment
 

00:03:27.140 --> 00:03:30.280 align:start position:0%
what you just saw radix add a comment
subscribe<00:03:27.710><c> to</c><00:03:28.130><c> our</c><00:03:28.220><c> chin</c><00:03:28.720><c> the</c><00:03:29.720><c> freedom</c><00:03:30.170><c> to</c>

00:03:30.280 --> 00:03:30.290 align:start position:0%
subscribe to our chin the freedom to
 

00:03:30.290 --> 00:03:35.190 align:start position:0%
subscribe to our chin the freedom to
learn<00:03:31.090><c> what</c><00:03:32.090><c> you</c><00:03:32.300><c> want</c><00:03:32.770><c> when</c><00:03:33.770><c> you</c><00:03:34.010><c> want</c>

00:03:35.190 --> 00:03:35.200 align:start position:0%
learn what you want when you want
 

00:03:35.200 --> 00:03:40.350 align:start position:0%
learn what you want when you want
absolutely<00:03:36.200><c> free</c>

00:03:40.350 --> 00:03:40.360 align:start position:0%
 
 

00:03:40.360 --> 00:03:43.990 align:start position:0%
 
GCF<00:03:41.360><c> learn</c><00:03:41.960><c> free.org</c>