A JOIN clause is used to combine rows from two or more tables, based on
a related column between them.In this article we are going to learn about INNER JOINS.Run the Sql query into phpmyadmin
It will select data from orders table whose customer id is equal to id which are in customer table.
SELECT orders.order_id, cutomer.cust_name,orders.order_date
FROM Orders
INNER JOIN cutomer
ON orders.Cust_id=cutomer.ID
ORDER By orders.Order_id;
It will select data from orders table whose customer id is equal to id which are in customer table.
SELECT orders.order_id, cutomer.cust_name,orders.order_date
FROM Orders
INNER JOIN cutomer
ON orders.Cust_id=cutomer.ID
ORDER By orders.Order_id;
0 Comments