we get same results using both the queries which are written below,then why to use joins instead of selecting columns from multiple tables with where condition as follows SELECT OrderID,CustomerName FROM Orders,Customers where Orders.CustomerID = Customers.CustomerID; with joins eample SELECT Orders.OrderID, Customers.CustomerName FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;
