SQL Joins(Inner, Left, Right Full Outer Joins) | SQL Full Course | SQL Tutorial For Beginners (6/11)

[@SairamV17]

Insted of taking A,B,C,D better pick names so it will not give confusion ha ha ha 😀 A,B,C is tricky but go with the names it will be easy ... I tried like that

[@AnalyticswithNags]

Ok

[@mouliappaji]

very well explained about the join

[@AnalyticswithNags]

Thank you

[@lakshmikanthparvathapuram1250]

Hi Sir, great video and very useful...one small doubt, in order to perform joins b/n the tables..do we need to define Primary key and foreign key relationship before it self b/n two tables? And if we perform joins b/n 3 tables and how the primary key foreign key should be defined b/n 3 tables? Could u pls clarify on this sir? Will be more helpful..thanks in advance

[@AnalyticswithNags]

Tables with primary key should be created first.
Followed by foreign key tables.

[@deepakiran5204]

Thanks for the vedio sir, can u please share the file table which u have used for join

[@AnalyticswithNags]

It is easy to create. I don’t maintain it

[@deepakiran5204]

Thanks for the reply sir, I have created new tables and applied join...u r vedios are really amazing and helpful....u r way of explaining concepts are good...thank you sir

[@kishanbhise4733]

sir how can we see which column of a foreign key table refers to which column of another table having primary key column

[@AnalyticswithNags]

What is Primary/Foreign Key, String Functions | SQL Full Course | SQL Tutorial For Beginners (4/11)
Watch this video in the Sql playlist

[@vinodjadhav7334]

Thanks for the Video.

[@AnalyticswithNags]

You're welcome

[@devendarn6738]

Hi sir
In the video between 44:00 to 46:00 you could not delete customerkey and salesordernumber from the table.
Like you said while explaining primary and foreign key constraints, a record cannot be deleted from a Customer_Cntr table when there's been a relation with Customer_Purchase table.
is this the reason why you couldn't delete those records? because FactInternetSales Table has relation with other table?

[@AnalyticswithNags]

Yes

[@devendarn6738]

@@AnalyticswithNags thanks for your simple reply 😜😄

[@madhan.s7166]

can we have 2 primary key in a single table ,
if no then can u please explain it at 29.45

[@AnalyticswithNags]

No. Primary rearrange the table storage. That’s is why it can be only one per table

[@ashishmohan4707]

Hi
Awesome tutorial
very useful video and very practical need everyone for every project ......very big thanks to share with us.
If it can possible can you plzz provide us excel data file which you used.
Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

[@AnalyticswithNags]

You are most welcome, will share it

[@SairamV17]

Im not get the results same as you (Joins) ... When i apply the syntex(Left join ) im getting all the fields like DOB,AGe,Gender ,... But i have mentioned only (custid,Custname,Product ) i tried again and again i dont know why its coming...
I have sent an email please hepl me Nag :)

[@AnalyticswithNags]

I answered in email

[@SairamV17]

@@AnalyticswithNags got it thanks Nag Sir 😊 now its clear 🙌