
Untitled
By: a guest on
Jun 2nd, 2012 | syntax:
None | size: 0.41 KB | hits: 12 | expires: Never
Do these MySQL SELECT queries represent different inner joins? [closed]
SELECT name, salary
FROM employee, info
WHERE employee.id = info.id;
SELECT e.name AS name, i.salary AS salary
FROM employee AS e
INNER JOIN info AS i
ON e.id = i.id;
SELECT e.name AS name, i.salary AS salary
FROM employee AS e
INNER JOIN info AS i
ON e.id = i.id;
SELECT name, salary
FROM employee, info
WHERE employee.id = info.id;