I need to select these fields-----
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
and
tri_title,
tri_subtitle
from res_partner table
where res_partner.partner_id = opportunity_history.partner_id
in a single query. how can we do that?
Thanks Adil
Why so many downvotes and no comments?
Try with:
SELECT
oh.ser_id,
oh.sales_vertical,
oh.partner_id,
oh.category,
oh.sub_category,
oh.stage_id,
oh.exp_revenue,
oh.action,
oh.action_date,
oh.title_action,
oh.date_action,
oh.details,
rp.tri_title,
rp.tri_subtitle
FROM opportunity_history AS oh
INNER JOIN res_partner AS rp
ON rp.partner_id = oh.partner_id
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With