Join role in sql

[sonamsharma]

What is the join in sql?

[arun7]

An SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them.
The most common type of join is: SQL INNER JOIN (simple join). An SQL INNER JOIN return all rows from multiple tables where the join condition is met.

[simar]

It is used for combine rows and tables.......................................

[ankigupta]

sql join is very helpful , we used join for clubbing the attributes of two or more tables.

[jesslee]

Join is used to combine the attributes of two or more tables by using the join Query.There are two types of join inner join and outer join.

[niharikadutt]

Sql join means combined rows from two or more tables based on common field between them.

[melvinscott92]

Join query is used to whenever gathering the data between the two tables then we can used the join concepts...

[suhanarai]

Join operation is most important in Sql without join it is difficult to combine rows or data from two tables

[Rosa]

Join is the keyword used to combine data's from different tables.

[Marie]

Join is used to combine two or more rows in a table.

[zinist]

Hi,
1)Whenever you want to perform action on more than one table you can use join.
2)As name suggest it is use to join two or more tables.

Thanks