title: double select statement issue, multiple rows returned , subquery returned more than 1 value
body: <p>ok, here it goes, I have 3 tables: </p>
  
  <pre><code>accounts             ( account_id,      employee_id, account_name )
  projects             ( project_id,      project_name )
  project_distribution ( distribution_id, employee_id, project_id )
  </code></pre>
  
  <p>What I want to do is to return the project names from the project table if i have the project ids from the project_distribution table.So , let's assume that i have employee_id, i'm going into project_distribution and do a select, I get 2 values for project_id ,id 1 and 2, how can i return the project_names for these two IDs without doing 2 querys or statemens or how are they correctly called, here is my bad select statement.</p>
  
  <pre><code>SELECT project_name
  FROM   projects
  WHERE  project_id = ( SELECT project_id
                        FROM   project_distribution
                        WHERE  employee_id = ( SELECT employee_id
                                               FROM accounts
                                               WHERE account_name = 'tbogdan'
                                              )
                      );
  </code></pre>
  
  <p>oufcorse I will get 2 values from project_distribution,and a "Subquery returned more than 1 value" error  how can I fix this , and make it work?
  If more info is needed, please ask...sorry for vague description...</p>