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;
__________________
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|