title: Hive lateral view explode with 2 table joins
body: <p>Checking to see if this is possible in Hive:</p>
  
  <pre><code>Select a.col1,b.col1
  from tableA a join tableB b on a.col1 = b.col1
  lateral view explode(numcred) tableA  as creds
  where creds.id = 9;
  </code></pre>
  
  <p>I can not find the answer in the docs. In short:</p>
  
  <p>I want to JOIN on two tables AND LATERAL VIEW EXPLODE TABLEA</p>
  
  <p>Seems simple enough but throws syntax issue.</p>