SQL Join query is used to join the two tables i.e add or combine two or more tables .
This clause take data from two or more table in database and then combine them to produce new table .
Joining is based upon the common fields from the tables . Advantage :
Using this you can access more than one table with the help of select statement . Join has 4 types : *1) Inner Join : * it also known as simple join , it is widely used .