title: can I solve MySQL query without using join?
body: <p>I want to solve this mysql question.
   Q.) employee(employee-name, street, city)
       works(employee-name, company-name, salary)
       company(company-name, city)
       manages(employee-name, manager-name)</p>
  
  <p>where employee, works, company, manages are tables of mysql.
  and name in braces are columns for respective tables.
  My question is..
  How to find all employees in the database who live in the same cities and on the same streets as do their managers?</p>
  
  <p>Managers are also employees. So their address is also stored into employee table.</p>
  
  <p>so far I have tried this query and many other queries..</p>
  
  <pre><code>select employee.employee_name 
  from employee,works,company,manages 
  where employee.employee_name=manages.employee_name 
  and employee.street in 
      (select employee.street 
       from employee,manages 
       where manages.manager_name=employee.employee_name);
  </code></pre>