Nested Queries | SQL | Tutorial 18

Very good breakdown, thank you!

This was so helpful! Thanks

Awesome video, thanks so much

We can use inner join

for second query, we could also use

SELECT client.client_id, client.client_name
FROM client
WHERE branch_id IN (
SELECT employee.branch_id FROM employee
WHERE employee.emp_id = 102
);

Can you do this if your trying to pull from separate dbos? Or do I have to create a view with the info from each dbo I need?

nobody uses where subqueries just write a nested left join lazy people maybe

nice explanation 😇 sir

Hi, thanks for the video! Sorry I don't get it why in the first example you were using 'IN', while in the 2nd example you were using '='? Can you explain a little detail, please? Thanks.

Great explanation!!!

Subscribed!!! Great videos with C and now SQL.

why not just use join?

Taught me something my teacher couldn't, appreciate it

Thank you. Help a lot

i need this with calculated columns. any suggestions?

Great video 👍🏽

Great video!!!👏

hey mike, thanks for explaining the complex topic in SQL nested query!

Thank you! Your explanation is so clear!

These can be done by using JOIN.

To make it simple, why don't use "in" in all cases?

Fantastic videos, all of them. Thank you for doing this.

Thanks for simplifying the logic behind this!

THANK YOU! BEST tutorial out there! Had no idea what was going on it class for the past 40 minutes and you sorted it in 10 😂

bravo

nice video i want this types of more scenerio base questions solutions

believe it or not our database design lecturer did not use practical example like this and just read of what syntaxes does from textbook. holy i just understood it in a minute!

Love how you used people from the Office!!!

left join ftw

Great content, thanks.

OMG, I was struggling with Nested subqueries, but now I certainly have a better insight about it. Thank you so much and the person who shared your video in a forum.

I come here from the google data analytics professional certificate and this video allowed me to understand this new concept. Thank you very much.

Awesome explanation for nested or subqueries. Thanks so much!

Just 30 minutes ago, I upload a doubt. With the help of a mate, I got the answer right the way, great community!

I don't understand fully the direfence between 'IN' statement and '=' command

Hi, I liked working on the data camp, are there any websites with a lot of tables and questions to solve more problems and practice?

u are so good tbh , very clear

this is the code i came up with for the second question, can anyone tell me if it is correct

select works_with.emp_id
from works_with
where works_with.emp_id in
(
select client.client_name
from client
where client.branch_id = 2
);

Just wow ❤🙏🙏🙌

Can you make video of if condition and while loop as well please

Thank you. It really helps!

In the very first subquery example, how would you display the client id as well along with employee's first and last name? I am happy if it repeats the name.

I'm still confused about the difference between the 'IN' and the '=' , any explanations? thanks in advance. Great video!

This was lit 🔥 Thank u bruh...

my profs couldn't even explain this as clear and you, and i paid her for the class.........

my approach:
SELECT client.client_name
FROM client
WHERE client.branch_id=(
SELECT employee.branch_id
FROM employee
WHERE first_name='Michael'
);

Thank u so much!
can you make more advanced paid courses in SQL, Back end Developer with economical for students.
you teach so well.

Thanks, Dane, you're Great.

Amazing tutorial