And in the heart and in the whole tourism operators that you would see very often on a skirt suit.
So this was an opportunity to talk about them.
First, we are going to see the head.
What does the hand to the hand operator allows you to join several condition in the query it applies
to will wear filter and clothes, requires both condition to be met true or to query.
OK.
And it's service in syntax select from my table contact where a month date of birth and quarter zero
eight and edge greater than 16.
OK, so a select people who were born, you know, who've used and and also those who are over 16 years
old.
If one of the condition is not respected it.
If, for example, as age grade 16, the query doesn't return anything because one on the condition
of the query is not respected.
OK.
Anyway, we will see Boris for this in the demonstration afterwards.
Of all is a bit similar to the hand, except that it requires only only one condition to be made, do
we tune the query?
It applies to the whale filter.
The syntax is select formative formatted when M., A., M. O.
O name again is OK.
So think of a name of a person who has been in a war, all the name.
Iguana is OK, but if my first condition, mono doesn't, this does not meet my search criteria, I
can take her name, Eastwood in my query.
OK, so to make it clearer, let's see this in demonstration of it.
So let's both forward them ending.
Oh.
I do acidic contactable, yeah, though always nice 16 rows inmates there.
OK.
Michael Jackson and Natalie Portman.
OK, we will start with the end and the beginning, I want to select the men who are less than 41 years
old.
OK, so let's get to look on Macquarie, where gender equal model and age under forty one years old.
OK, so next, execute this query.
Now you can see that specifically.
So I took only my sex and we persons under 41 years old.
OK.
In my area of a query, I want people born in August who are over 16 years of age, OK, where a month
that date of birth equals zero eight father August if an age greater than 16.
This exec mix, Quibi.
These are zero world works perfectly, OK, no problem, we how to Quibi's so I told you in the has
shown the hand crews requires both conditions to be met in order to return this query.
Here we take the same cookie, but I put hedge equal one on one one, for example.
OK.
Just here.
Age 100 zero, what?
Value when one does not exist in Makarand.
So here I take the month of August and the condition age one on one what we eat walk.
Here we see the eat unenthused thing because there is a condition that's not respected, despite the
fact that there are people who were born in August, Saigon clothes, people born in August exist,
but there is not an inch one on one one saw the condition is not respected.
The request doesn't relate to anything.
OK, you understand Vera Hall.
On the other hand, the Hova hands hobby only requires that OA condition one condition be met if they
play the same query that he's here.
By replacing the end.
We've ha all here.
I replace a replace and we've all so I have a condition that he's good.
However, hedge equal one ondan one is not very it's query.
Here we see that the crew returns, returns, people who were born in August.
OK.
It didn't take into consideration the age that is equal to one on one one.
But it took into consideration the condition that is valid the condition of August.
OK.
This is the main difference between and here, and if I take the people who were born in a month in
the month of August and how all 16 years whole OK in this group.
We would see an interesting case there, birth condition will be met, the date of birth and the edge
greater than 16.
OK, so let's execute this quickly.
Here we have a unique test case victory took hold whole review walls all of line.
Why?
Because it has accumulated both condition or views where you were born in August and hold those who
are over 16 years old.
OK, so people who were born in August and Herzl, who are over 16 years old.
In fact, the two conditions were met, so it has committed to result together because it has resulted
in the people who were not born in August.
OK.
This is the difference between the hand and rule in the heart, if you said severe condition it take,
it takes about half of the roll over of line there that her injuries condition OK, the hand we filter
in, we'll see if buff condition are met.
Let's get a look on the Nunavut query if I want Foy's on Burnham.
The name of Isherwood and Moreau in the same Cary.
Select.
Very resolute, very quickly, it wasn't nothing.
It doesn't work because the hand cannot be her to all the semicolon.
We will then leave on the hall effect change and by the fall.
It is going now we are we have the goods.
It is food and kit.
OK.
So there you go.
I hope you have learned more about hand in the hole.
And we will see them in the exercise that I going to to give you later so that you can practice on this
too close to that heart beats this shoulder, but you will see very frequently in you as quickly.
OK, so let's go onto the next section.