All language subtitles for Self Join

Recording in progress.

Session we discussed about joints.

What are the types of joints that we have in?

And he dines.

When people in online blame it.

What are the types of girls?

We have inner joins inner join and outer joins.

And.

What is the keyword that we have in inner join?

What is a joint that we have in emergent.

What is a key word that we have?

Which joint do we use in industrial?

Normal join only.

Join is the keyword.

What will be the output of inner joy?

It will do only matching values between both the tables.

It will give only matching values.

Will you?

Only matching values between both the tables.

In outer joints.

What are the keywords that we have?

What are the keywords that we have in outer joins?

Left join.

Right joint.

And we have one more type of giant is called Full Giant.

It is not a keyword.

We have one more type of join is called a full join.

What is the purpose of using this outer joints.

Now, James is used to fetch matching values.

What is the purpose of using outer joins?

It will give both matching values, plus unmatched values.

Matching values plus unmatching.

What will be the output of left Adjoint?

What will be the output of left join?

Matching values from both the tables, plus unmatched values from left table.

Unmatched value solely from left table.

Similarly, right joint matching values.

Plus unmatched values from right table.

Unmatched values from right to.

What is the syntax of full join?

What is the syntax of full join?

What will it give in the output?

What is the syntax of Wolverine and what will it give in the output?

Syntax for full join is left join union right join.

What will it give in the output?

What are you going to get in the output?

What are you going to getting output here.

In the output of.

Matching values.

Plus, unmatched values from both tables.

Both left and right tables.

Okay.

This full Jane will give matching values plus unmatched values from both the tables.

Beyond that, what are the types of joints that we watch?

What are the remaining joints that we have?

Saying cross join.

And self-driving.

Project.

What is the purpose of using Crossrail?

I think it will do all possible combinations between both the tables.

All possible combinations between both the tables.

What is the another name of Crossgen?

Cartesian product.

Why it is called as Cartesian product.

Output of the crossgen will contain.

The product of number of records present in first table and the product of number of records present

in second table.

For example, in table one.

If we have four records and table two.

If you have three records in the output result set, you will have two records.

That is why it is also called as a Cartesian product.

After that, I gave you a task on Self-join.

Self-join.

What?

What does this self-join mean?

What does it mean?

Yeah, we are joining the same table.

I think.

Joining.

The same table with itself.

Joining the same table with itself is called self join.

Why do we join the same table with itself?

Why?

What is the purpose of joining like that?

And someone.

No library was destroyed.

I gave you an example.

I gave you a task.

How many of you it?

I gave you a task on Self-join.

I gave you a table with three columns called employee ID.

The employ name.

Unmanageable.

Manager name.

Yeah.

An employee name column there.

Names of the managers.

Right.

Who is the manager for?

Who is the manager for Sana.

Who is the manager for John.

Who is the manager for Peter?

Where are their names?

An employee name table.

Their names are present.

Then why can't you fetch them?

I told you the same same inner join or outer join query.

You can use any left, join or inner join query and you can try for it.

In normal joints, which condition will you use?

What is the condition that we are going to use?

I asked about condition.

Which condition are we going to use?

We are going to use on condition.

This arm condition is used to find matching values between both the tables.

Is used to find the matching values between both the tables.

Okay, let me create this particular table and let me.

Rachel's joy.

Okay.

Create table.

Employee table.

We have columns called employed.

Just until you can take 3 million tons of.

The employee name.

You just collect property?

Manager, Eddie.

Just again until.

After that we can control enter to execute.

Just.

The employee table got created.

To see it in the output.

Execute select star from employee table.

Implied table.

The gun control enter to.

Here we have employee table with three columns called employee ID, employee name and manager ID.

After that insert values into this particular table.

Insert into.

The employee table.

Values.

Employed one.

Name.

Manager null value.

Sorry.

Employee one.

You can give name as periods as use the.

Manage writing values.

Mulk.

In.

We can give him values we cannot give in table names and column names.

For values we can utilize as per your wish because values will be treated as from semicolon to semicolon.

Sorry, quotation mark to question.

Quotation mark.

From this starting quotation mark to ending quotation mark, it will be considered as a single value.

For example, if you remove quotation mark here, the whole null value this commas and all will be considered

as same value.

This bracket will become the same value until you close the.

Rotation.

The table names in between table names and column names.

You can't give any space.

ID number two.

Known.

Nonetheless one.

Employee number three.

Learn some of.

Manager Radius one.

Employee ID number for.

Name?

John.

Manager.

It is.

They?

Which is the employer of someone.

Employee.

The number five.

Then, Peter.

It also managed redistrict after that, execute this particular query.

After that execute select star from employee table.

Here.

I got complete table in the output with columns, employee ID, employee name and manager ID.

And from some time it.

I love you.

Create this particular table.

After creating this particular table.

Right.

A normal joint ballistics.

Select.

What are the columns that I want?

Employee ID?

Employee name.

I want one more column called Management.

I want one more column called Management.

In which column am I able to see this employee names?

Borough manager names.

In which column am I able to see the name of Bill Gates on and.

In employee name, I am able to see their names one more time.

I will take employment.

I will rename it as.

Management.

From.

In-flight table.

I'm taking a less nervous even.

Groin attack left joint.

Again take the same table.

Again, take same table, same employee table.

New alias name as P2.

I am joining the same table with itself.

After that, I'm mentioning the table names for column names.

This employee id I'm fetching from employee E1 table.

Even dot employee ID.

This employ name I am fetching from E1 table e1 dot employee name.

His second employee name am fetching from E to table.

E2 Table E to table from second table.

I'm fetching this particular column.

The same column, but for when I am when I am taking this table for the second time, I am renaming

it as E2.

From this second time table, I am taking this employee name column.

For taking this particular column I am using some condition on.

Even dot manager ID.

ID is equal to e two dot employee id.

Wherever manager ID value is matching with employee ID, they'll fetch their names only print their

names only.

Whenever this manager ID is matching with the employee id print his name.

Whenever this manager ID is matching with this employee ID, print this name.

When our manager is matching the employee ID, print the employee name.

After that you can control enter to execute.

One minute.

Sorry.

If we execute this particular query, you will get a column called Employee ID, Employee name and Manager

Name.

After executing this particular query.

I love you.

Practice all the joints.

All joints.

All remaining joints.

Because this is a very important topic.