3 ms·
well, FROM should not be needed unless you are aliasing table names So ideally it would be SELECT Employee.Name, Address.Street WHERE ... GROUP BY
by systems 3y ago
well, FROM should not be needed unless you are aliasing table names
So ideally it would be
SELECT Employee.Name, Address.Street
WHERE ...
GROUP BY
HAVING
ORDER BY
or
FROM Employee AS EMP , Address as A
SELECT EMP.Name, A.Street
WHERE ...
GROUP BY
HAVING
ORDER BY
We should always use fully qualified names is the select
And optionally ommit them in further down clauses such as WHERE or ORDER BY
if the names are unambigious