I have two tables in database one is
Orders and another one is
Orders Table Contains : OrderID , CustomerID and OrderDate
Customers Table Contains: CustomerID , CustomerName , ContactName and country
Actually the "CustomerID" column in the "Orders" table refers to the "CustomerID" in the "Customers" table. The relationship between the two tables above is the "CustomerID" column.
Query with Join
SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate FROM Orders INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID;
SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate FROM Orders,Customers WHERE Orders.CustomerID=Customers.CustomerID;
Result of Both Queries is : OrderID , CustomerName and OrderDate
On both the above query i get the same result . I want to know the difference between these queries and if we can do it via SIMPLE query why use JOIN?