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;