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