|
|
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?
Navigation:
[Reply to this message]
|