Join In MySql



SUMMARY 

In this tutorial we will learn what is join , Join types in MySql, Join syntax in MySql, Join tables in MySql.

What is join

Join is a query which can fetch or retrieve data from more than two tables. Join in MySql is very important task for a dba where we need details data from more than two tables. Then we can us join operation to fetch details data as per our requirement.

Join types in MySql

There are four types of join in MySql. 1.inner Join: Suppose we have two tables. Using the inner join we can retrieve data from these two tables which data are matched . 2.Left Join: Suppose we have two tables .Using Left join we can retrieve all data from the left table and matched data from the right table. 3.Right Join: Suppose we have two tables .Using Right join we can retrieve all data from the right table and matched data from the left table. 4.Cross Join: Suppose we have two tables ,one is employee table and other is department table. Department table has five records and employee table has three records. Using cross join Each row of the one table is join to every rows of the other table. After joining two tables we will get 15 records. Normally cross join is not used.

EXAMPLE FOR JOIN

Please see this above video to explore join with example for mysql.

CONCLUSION

In this tutorial we have learned what is join , Join types in MySql, Join syntax in MySql, Join tables in MySql.
For more details visit:techrideradmin.blogspot.com