Help Req

Hi,

    I have a question to ask. i have a set of relational databases specifies as :

        employee (employee-name,street,city)
        works(employee-name,company-name,salary)
        company(company-name,city)
        manages(employee-name,manager-name)

    Q) How to find all employees in the databases who live in the same cities

         and on the same street as do their managers?

1. select distinct employee-name from employee, manages (select employee-name,street,city from employee,manages where employee.employee-name = manages.manager-name) as manager(manager-name,street,city) where employee.employee-name = manager.manager-name and manages.manager-name = manager.manager-name and manages.manager-name <> employee.employee.name and manager.city = employee.city and manager.street = employee.street

--
Regards
Low Y S
ICQ:3140912
Pse return mail to: slasher_at_edsamail.com.sg
(P.S Not more than 500K attachments)