Joins in MySQL || Introduction to Joins || MySQL Tutorial
In my previous video of MySQL series I have discussed about group by clause in MySQL
You can check the video from the above I button
Today we will be discussing about joins in MySQL
Why do we need them types of joins with example
So without any further delay let's get started
We know that SQL is a programming language that is used to interact with relational database
In a relational database data is stored accross multiple different tables and all of these tables are related to one another in one way or the other
For example, we have a table of states with the name of each state and various other attributes & another table with a list of states and their capital cities.
And we want to fetch the data of state with there capitals then we will use join statement
A JOIN statement is a SELECT that combines records from two tables into a results table based on some condition, called a join condition. The condition tested might be whether two field values are the same, so that records having the same values in that essential field can be combined from the two tables into one table. Joins can be nested to combine records from more than two tables into the results table.
A typical way of using a join statement would be to add columns to tables by looking up matching values in other tables.
And that's all for today Hope you all will get some help from this video
If it's so then don't forget to subscribe my channel Code with Neha and press the Bell Icon for Regular Updates
See you in the next video till then Stay Safe Stay Happy
#SQLJOINS
#JoinsinSQL
#SQLJoinsTutorial
#SQLJOINSTutorialforbeginners
#SQLJOINQuerieswithExamples
#introductiontojoininsql
#Joininmysql
#sqljoins
#sqltypesofjoins
#sqljoinstutorialforbeginners
#sqljoinswithexample
#sqljoinsexamples
#SQLqueriesusingJoins
#SQLJoinqueries
#joins
#joinsindbms
#typesofjoinsindbms
#needofjoins
#joinsexample
#joinvssubquery
#typesofjoins