Learning MySQL - Multiple JOINS

When running a user defined function, is it important you reference it to a table like your syntax included 'from people'

Amazing explanation

Can I use this db file in mysql workbench?

hello mr. how to join two row join same table, how to maintain woocommarce product

I thought I was good enough for db only to come back in this video not knowing anything about joins. Thank you for this! Question though: if I have a query of

SELECT std .name FROM student as std
LEFT JOIN room as rm ON rm.student_id = std.student_id
LEFT JOIN class as cl ON cl.room_id = rm.room_id

I know that student table is the Left table for the first join. What would be the Left table of the second join? Is it the class table or the room table?

When combining multiple joins like Left then Right then Inner, does that cancel each other? Thank you for the reply, Prof Steve.

Hi Steve. Instead of selecting from the Productline table if one selects from orderDetails table instead will it have performance issues? I mean deciding on the MAIN table in a select statement with a JOIN clause

Thanks for help

Thank you :) have a SQL interview next Thursday and studying. Great speaking voice and clear video!

This is super helpful. Thank you.

your voice is amazing

The script to create the DB failed to run in a Postgres12/PgAdmin4/Linux. One example of syntax error is: int(11).

Thank you very much Steve! This was very helpful! I got one question though. I see that in your relational data base the join path you followed was like a chain. However, if you wanted to select a colum from the "payments" table, how would you do it? I have one of those cases and I haven´t figured out how to reach that other table that is not in the same linear path.

That's such a great video with an exceptionally cool explanation of the theme.

Glad to watch this as this cleared a big doubt of mine!!

keep it up 👍.

Hi, I want to practice with your videos. Although I'm not sure where to run these queries when I click on the link. Where should I go?

Thank you, thank you. just what I needed to figure out my query.

Nice work Steve, you're a godsend. Thank you.

My gratitude is infinitely endless and heartfelt. Thank you.

Thanks again for these videos! You're fantastic. I hate to ask, but is there a PDF or image file of this ERD? If not, I can screenshot it. Thank you!

hello steve, i wonder u have videos about database optimization? like indexes, how to deal with locking etc... anything that improve database performance, bec that is really my biggest problem right now, website is slow

Hello Steve, if I want to create reports in MS SQL Server. Which tool is better the Report Builder or the Visual Studio (Data Tools) or something else?

Do you have few exercises to practice on this customer database.?

Steve, can you do a video on how to architect a huge project like this or something like an ecommerce on MYSQL? Like how many tables we would need and how to connect them together.

The world is run on databases.
Nice series, clear and concise.