title: how To select fields from two tables
body: <p>I need to select these fields-----</p>
  
  <pre><code>user_id,
  sales_vertical,
  partner_id,
  category,
  sub_category,
  stage_id,
  exp_revenue,
  action,
  action_date,
  title_action,
  date_action,
  details from opportunity_history table
  </code></pre>
  
  <p>and </p>
  
  <pre><code>tri_title,
  tri_subtitle 
  from res_partner table 
  where res_partner.partner_id = opportunity_history.partner_id 
  </code></pre>
  
  <p>in a single query.
  how can we do that?</p>
  
  <p>Thanks Adil</p>