hi all ,
why to use parenthesis at the beginning and at the end of the "from clause query" like that :
(SELECT e.First_name
,e.last_name
,e.phone_number
,e.hire_date
,d.department_name
,m.last_name||', '||m.first_name as manager_name
FROM employees e, departments d, employees m
WHERE e.department_id = d.department_id
AND e.manager_id = m.employee_id)
craig say so , but did not say why .
thanks