Posted by Gosiek on 08/29/05 16:18

Hello everyone,
I want to select employees and products which they bought. I did it in
two ways:

SELECT Employees.Name, Orders.Product
FROM Employees, Orders
WHERE Employees.Employee_id=Orders.Employee_id

SELECT Employees.Name, Orders.Product
FROM Employees
INNER JOIN Orders
ON Employees.Employee_id=Orders.Employee_id

My question is: which way is faster?

[Back to original message]