What is Join operation.?

[tulipviolet]

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;