What is Join operation.?
 

What is Join operation.?

Join operation, is an operator that JOIN the data between Tables of database.
There is INNER JOIN, OUTER JOIN, LEFT JOIN, RIGHT JOIN, all with different purposes.

join operation used to join the table in the database
left join
right join
full join
inner join
outer join

exp;--SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate
FROM Orders
INNER JOIN Customers
ON Orders.CustomerID=Customers.CustomerID;

Join operation is used in SQL to return rows from multiple tables where the condition is met.