title: Query inside query on google spreadsheet
body: <p>I need to query data from table and for where clause use result from another query</p>
  
  <p>For example:</p>
  
  <p>How to query for rows at this tab where date on column A is greater or equal date from another query on the tab shown at second image below. I want to write only the project number on the query or put a cell with the current project number and query for start and end dates where project is equal current project.</p>
  
  <p><a href="https://i.stack.imgur.com/8Uup2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8Uup2.png" alt="Project Tasks"></a></p>
  
  <p><a href="https://i.stack.imgur.com/8Uup2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cUacQ.png" alt="Project Dates"></a></p>
  
  <p>The query will be something like this:</p>
  
  <p><a href="https://i.stack.imgur.com/6H5JW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6H5JW.png" alt="Example Query"></a></p>
  
  <p>Can you help me?</p>