SQL Tutorial - 29: SQL JOINS

In this tutorial we'll take a look at SQL JOINS and see how we can pull data from two tables through a single query!

[@mohitnehete2]

Watching in 2024😢

[@suravshrestha5623]

Very simple and to the point explanation of how JOINS work in SQL.

[@max5175]

Great tutorial. I was pretty intimidated by JOINS but you made it nice and simple. Thanks man

[@Dartholit1]

Thank you so much for you SQL videos!!! I'm passing my database class thanks to you.

[@rockxiong8264]

Thank you very much for the second part. Most of the videos on joins doesn't include the second portion of this video where you utilize the "where" clause. Earned yourself a subscriber.

[@k_oliver]

One of the simplest and yet ery helpful tutorial Ive found! thanks man! keep this up :)

[@joan.nakibuuka1322]

I'm new to this and you are making it way easier than i imagined. Thank you

[@timchunk1248]

Thank you ! I view this video twice, and i learned join!

[@nyanganjikingsley4664]

I love the way you present your tutorials sir

[@yuratea1700]

Thank you so much for your time and your awesome explanations. Greetings from Lithuania! :)

[@sarangrb1375]

This is all I needed looked for hours and hours and couldn't find anything solid. Great work man thanks👍🏻👍🏻

[@madhurbhatia89]

Thanks Sarang, glad you found this helpful :)

[@shckwave5230]

@@madhurbhatia89 speak in Hindi for better explanation

[@Runderwunderknopf]

Oh Maaaan, your Turoials are awesome! Thank you!

[@blainejantze6565]

Great Tutorial, makes JOINS look easy

[@ShoppingStew]

Thank you so much for these tutorials!

[@ryanmccleave3562]

Love this tutorial, thank you!

[@tetsuoshima454]

Already passed mid-way mark. Great work.

[@wayup7985]

Great tutorial man. Big thumbs up brother!

[@azanshaikh7825]

this wasn't bad at all. Thank you,kind sir!

[@test_132]

Thanks for sharing I just learned joins!!!

[@humanbeing4684]

Thanks a ton, This has greatly helped me, I am defintely going to share with my friends who is looking for join tutorial Also, I just subscribed you

[@sadatakhtar5927]

You explained that really well, thanks

[@zxvb778]

IT helped me alot sir keep making vids but iam 11years trying to learn sql it helped me alot thanks..

[@leenalzebn6176]

Very useful and straight to point thank you

[@AliAnsari14]

This is the best way to perform an Excel VLOOKUP in SQL, thanks

[@anassel98]

Thanks, helped me a lot!

[@rajeshakkineni5127]

Simply super bro.. you made my day

[@preethivaidyanathan3368]

So helpful, thank you!

[@Pchbt]

Very clear, thank you !

[@emaduddinzafar7207]

Khush raho yaaar asan krdeya tumne ❤️

[@k___T1151]

tnx ,you explaind it in a simple way

[@ParentFor07Cats]

it is just awesome man thanks :)

[@sofianetech379]

thank you so mutch the firs method is awsome

[@darwish2098]

That last bit of the video was helpful to really understand the Joins since I use the 'less preferred one but more commonly used' lol didnt event realize it

[@badarlasaiteja9172]

The second method is called equi join we use = operator and first one is using join keyword . Nice explanation for beginners

[@leonardbukenya8618]

Great stuff!

[@MohseenAttarVlogs]

Super Like I am a beginner you made it simple Thank You !

[@salmanfaris4679]

its very helpful tutuorial,thanks bro

[@kanikasharma9503]

your videoz r vryy helpful!!!

[@karanjesrani6889]

was very helpful simple video!!

[@taz3592]

Nice tutorial!

[@darshanabhuyan8479]

Excellent explanation

[@sparrowp2251]

btw very simple and easy to understand thanks!

[@ninaa7661]

Suggestion to show both tables on the screen while creating JOIN query

[@dipeshparma8605]

What

[@mosessamuel6918]

Pro tip : watch series at flixzone. I've been using them for watching lots of of movies lately.

[@marcusnash2001]

@Moses Samuel Definitely, been watching on flixzone for years myself :)

[@dustinfranco9201]

@Moses Samuel Yea, have been watching on Flixzone for years myself :D

[@woedemgodoga5624]

Thank you. well understood. Can you please do a video on left joi,right join and outer join

[@doenil470]

You a genius.

[@rodm8113]

better than my uni professor!

[@kmlearnchannel9415]

Well explain and clear

[@mattallen9406]

Thanks boss! This SQL sh*t is light work.

[@Rawman_56]

By giving example like this you are automatically getting my likes😊

[@JATINKUMAR-qu4vi]

Really helpful

[@diptijain]

Thank you

[@eriktorres6067]

Nicely explained without extra bs

[@ae1550]

Superb

[@LiuLinplus]

It helps,thx.

[@sparrowp2251]

tbh nobody ever really told me that joins were difficult !i guess it is one of the pros self studying hahahaha

[@okkamagad]

Hey Madhur, i see that we got 12 results when we used the Join query, but we got 13 results when we used Where clause, can you explain this briefly ? is it not recommended to use where clause for this kind of queries ?

[@iostream_gaming3184]

Suppose you are given a relation grade points(grade, points), which provides a conversion from letter grades in the takes relation to numeric scores; for example, an “A” grade could be specified to correspond to 4 points, an “A−” to 3.7 points, a “B+” to 3.3 points, a “B” to 3 points, and so on. The grade points earned by a student for a course offering (section) is defined as the number of credits for the course multiplied by the numeric points for the grade that the student received. Given the above relation, and our university schema, write each of the following queries in SQL. You can assume for simplicity that no takes tuple has the null value for grade. a. Find the total grade-points earned by the student with ID 12345, across all courses taken by the student. b. Find the grade-point average (GPA) for the above student, that is, the total gradepoints divided by the total credits for the associated courses. c. Find the ID and the grade-point average of every student. LODI PA TUTORIAL NGA NITO PARA MAY GUIDE ME SA SUNOD NA ACTIVITY SALAMAT

[@JATINKUMAR-qu4vi]

Thank a lot 👍👍

[@madhurbhatia89]

Thanks for watching!

[@hlokomani]

cheers man

[@donny2123]

thank you.

[@smtbhav3014]

Hi Madhur, I am trying to create a table in sql workbench where i want create a column where i want to insert ip address but not sure which data type should i select, so could you help me with the correct data type for ip address.

[@katara4955]

what would the query be if I wanted ALL the columns from both the tables? Do I still have to type out each column? Is there a shorter way? like Select * from both tables and join them somehow?

[@billiejl6237]

THANK YOU!

[@madhurbhatia89]

+Billie JL Cheers!

[@sentimentalisme61]

Hello thank you for you tuto what is the interface that you are using ?

[@at5music622]

Did you make id in the second table as primary key?

[@29ibrahimsayed95]

awesome

[@yanirazelaya5378]

Excellent work, The bad Tutorialssssssssss

[@madhurbhatia89]

+Sonia Chavez Thanks for watching!

[@AnonP2X3YZ]

thanks

[@Showtime_Southside]

What is the query to find no in ascending or descending order from 2 different tables at the same time?

[@VampireHeartization]

You can actually notice that the amount of results when using an Inner Join is 12, and then after you removed it to use WHERE, it is 13. I was wondering what are you missing out on?

[@osamaghazal2480]

If anyone here can help I tried following exact the same steps to execute the join command but it didn't work ? Is that because he populated the id column in the tutorial_info table from the old tutorial or what ?? and if we have to fetch the id column from the old tutorial, what is the syntax for inserting the remaining values (views, likes, dislikes, shares) without writing the id value ? how can we skip that?

[@SahitiSeemakurti]

Nice Tutorial, especially when I watch it in 1.5X speed. Also, This JON example you did, is it an INNER JOIN or OUTTER JOIN? How do you distinguish these two JOINs in code?

[@abhijeetgupto]

Sahiti Ss exactly , how to distinguish?

[@MotoGPFan33]

I am having trouble finding help on how to do Insert Into Select w/ join feature . I have data in table 1, which describes a motorsports racing session. I have table 2 which has information about each of the riders including their bike number, team , manufacturer, name, etc. - both tables have a column Rider ID, where the Riders table (table 2) has Rider ID as the primary key, and on the Table 1 , Rider ID is the foreign key. I want to write a insert into select join statement that merges in the individual rider data such as bike number, team, manufacturer , and name - into Table 1 . Can you help me please?

[@Showtime_Southside]

What is the query to find out highest values from 2 different tables at the same time?

[@gtry-bq5mw]

hi, do i need to put 'AS' in clausing the table? sorry, i'm confused

[@kaoutarlkhou4232]

no need for triggers, to join 2 tables?

[@marijuanastoner27]

HI i used WHERE instead of ON and the same also functioned is this wrong.

[@successorantigha9466]

I have a question: what's the name of this new joined table? How can I see it to enable me to query it

[@pareshprajapati3282]

How can I add column named first name and last name from database employee to table name title with all the data

[@janarddansarkar3447]

can we join more than two tables?

[@Rajeeb701]

nice

[@real_anil9688]

what if we have to write 'officer's name' as a string it will end at officers .

[@joselitoreyes7187]

How to input: films starting with S and T in SQL. Thank you

[@user-ys2be4cx8d]

What kind of sql is this? I'm using oracle and it's giving me error "from tutorials as t" (@6:06) where t is underlined in red, saying SQL command not properly ended. What gives?

[@SatyamJhasatyam2410]

he is using MYSQL wrorkbench

[@ezabelaah9451]

Hi I would like to take sql training from you. Please let me know how much you will charge. Thanks

[@jamilamammadova4556]

How can I get sql file like in that video?

[@AbCd-zo5tb]

i don't understand why people don't like the video after watching it?

[@sadmanpranto9026]

You didn't explain why ON is preferred over WHERE.

[@JunaidMunirVlogs]

your name is good.

[@dherendrachaudhary6728]

we can perform join operation only when two table have same number of row and column.

[@ramakrishnannarayanan4202]

can you please provide the insert queries for your table.

[@damiantoczek4814]

(table).(column) = SELECT users.username, users.profiledescription,stats.postcount FROM users,stats; With Insert you do the same. INSERT INTO users,stats (users.username,users.profiledescription,stats.postcount) VALUES ('$username','$description','postcount'); You could also do: INSERT INTO users,stats (username,profiledescription,postcount) VALUES ('$username','$description','postcount'); You need to keep in mind that you can not have 2 same colum names in two tables, if you have 2 same column names you need to specify the table. 'table.username' or 'stats.username'. If you have only a "profiledescription" column inside the "users" table but NOT inside "stats" you do NOT need to type 'users.profiledescription'. @Edit, before people start crying and leaving shit comments on me, i know that Sai's comment is 1year+ old, this video is from 2014 and i still came hear and learned something. When someone watches this tutorial... he might also ask about the "Insert query"... so here is the answer (above).

[@dhanashrishete792]

@badtutorial What is 'CROSS JOINS'

[@abhishekshukla9970]

how to rename colunm?

[@shwetagarg6892]

SELECT column_name AS rename FROM table_name;

[@chandrapolineni2452]

I am using Oracle DB and while aliasing a table name i am unable to use AS. I had to use table alias like this " tutorial t". Is this because of Oracle dialect?

[@munawwarshaikh3143]

Assalamualaikum

[@tommyjones1357]

Alright, for those poor bastards out there trying to learning Kusto Query Language where tutorials do not exist, the translation would be: | join OTHER_TABLE on $right._COLUMN_NAME == $left._COLUMN_NAME This will merge the two tables where the column name is matches.

[@varunbhardwaj7032]

hi Madhur, what is ur email id?

[@munawwarshaikh3143]

Urdu my sikhaen plz

[@RavenTech1]

Am i the only one who didn't understand much?

[@jitendrasonkar6055]

Kya kya bolta hai Bhai Hindi bol Yaar Kuch samjh Nahi kya kya Kiya