0
0
Read Time:36 Second
INNER JOIN: is used when retrieving data from multiple tables and will return only matching data.
LEFT OUTER JOIN: is used when retrieving data from multiple tables and will return left table and any matching right table records.
RIGHT OUTER JOIN: is used when retrieving data from multiple tables and will return right table and any matching left table records
FULL OUTER JOIN: is used when retrieving data from multiple tables and will return both table records, matching and non-matching.
SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;SELECT Orders.OrderID, Customers.CustomerName
FROM Orders
INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;
Happy
0 %
Sad
0 %
Excited
0 %
Sleepy
0 %
Angry
0 %
Surprise
0 %
About Author
