title: How to run a hive query with a column value equals select of some other query
body: <p>I have two huge tables in hive and i have a to run a query of this sort: Example query:</p>
  
  <pre><code>    select
      employee_id,
      employee_name,
      employee_address,
      employee_join_date
      employee_travel_pincodes
      from employee
      where 
      employee_join_date = (select join-date from hr_records)
      and
      employee_travel_pincodes in (select _pincodes from hr_records) //returns     multiple records
  </code></pre>
  
  <p>What is best way to achieve this in hive, I can use a subquery but looks like it wont be the cleanest way to achieve the desired output
  I am using hive 0.13</p>