title: mutiple subqueries error.please let me know how can i solve this
body: <p>trying to run below code in hue editor but failing for mutiple subqueris.please let me know how to solve this.</p>
  
  <pre><code>SELECT a.app,a.app_content,a.app_provider,b.app,b.date_hr,b.transdate from
  (SELECT * FROM table1)a
  left join
  (select * from table2
          WHERE date_hr=(select max(date_hr )from table2
  
           and transdate=(select max(transdate) from table2)b
  on a.app=b.app;
  </code></pre>