george.web13

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.

__________________
Κατασκευή ιστοσελίδων | κατασκευή Δημιουργία site | Σχεδιασμός ανάπτυξη site | e-shop | Σχεδιασμός ιστοσελίδων

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;

__________________
http://www.tulipvioletgurgaon.co.in/

johnstyle

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