JOIN Operation
A join operation is a binary operation used to combine data or rows from two or more tables based on a common field between them. INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN are different types of Joins.
Example:
Orders (OrderID , OrderDate);
Customers (CustomerID, CustomerName, ContactName, Country);
Find details of customers who have ordered.
Query
SELECT * from Customers JOIN Orders
ON Orders.OrderID=Customers.CustomerID;
Output
Difference between Nested Subquery, Correlated Subquery and Join Operation
Joins are used to combine two or more different tables based on a common field between them with the help of this we can easily retrieve the data from multiple tables. So, In this article, we are going to discuss the JOIN Operation, and Subquery in detail. Let’s start with the JOIN operation.
Contact Us