What is a join in SQL?

1.	What is a join in SQL?
Answer» JOINS in SQL join ROWS from two or more tables BASED on a shared COLUMN. The different categories of joins are: INNER JOIN returns rows when both tables have a match. LEFT JOIN returns all rows from the left table, even if the right table has no matches. RIGHT JOIN returns all rows from the right table, even if the left table doesn't have any matches. FULL OUTER JOIN returns rows when one of the tables has a match. SELF JOIN is a SQL statement that joins a table to itself as if it were two tables, temporarily renaming at least one table. CARTESIAN JOIN (CROSS JOIN) returns the Cartesian product of two or more joined tables' sets of records. Additional Resources SQL Data Structures OOPs Java JavaScript Networking

Answer»

JOINS in SQL join ROWS from two or more tables BASED on a shared COLUMN. The different categories of joins are:

INNER JOIN returns rows when both tables have a match.
LEFT JOIN returns all rows from the left table, even if the right table has no matches.
RIGHT JOIN returns all rows from the right table, even if the left table doesn't have any matches.
FULL OUTER JOIN returns rows when one of the tables has a match.
SELF JOIN is a SQL statement that joins a table to itself as if it were two tables, temporarily renaming at least one table.
CARTESIAN JOIN (CROSS JOIN) returns the Cartesian product of two or more joined tables' sets of records.

Additional Resources

SQL

Data Structures

OOPs

Java

JavaScript

Networking

Discussion