SQL 如何从两个表中选择字段
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6544822/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
how To select fields from two tables
提问by Adil
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
谢谢阿迪尔
回答by Tudor Constantin
Why so many downvotes and no comments?
为什么这么多downvote而没有评论？
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
回答by love Computer science
select user_id, sales_vertical, partner_id, category, sub_category, stage_id, exp_revenue, action, action_date,title_action,date_action,details, tri_title, tri_subtitle
from opportunity_history, res_partner
where res_partner.partner_id =opportunity_history.partner_id
回答by kyrylo
Possible solution (not in single query)
可能的解决方案（不在单个查询中）
(SELECT user_id, sales_vertical, partner_id, category,
sub_category, stage_id, exp_revenue, action_date,
title_action, date_action, details
FROM opportunity_history)
UNION ALL
(SELECT tri_title, tri_subtitle FROM res_partner
WHERE res_partner.partner_id=opportunity_history.partner_id)
(SELECT user_id, sales_vertical, partner_id, category,
sub_category, stage_id, exp_revenue, action_date,
title_action, date_action, details
FROM opportunity_history)
UNION ALL
(SELECT tri_title, tri_subtitle FROM res_partner
WHERE res_partner.partner_id=opportunity_history.partner_id)
回答by Balanivash
SELECT a.user_id, a.sales_vertical, a.partner_id, a.category, a.sub_category,
a.stage_id, a.exp_revenue, a.action, a.action_date, a.title_action, a.date_action,
a.details, b.tri_title, b.tri_subtitle FROM opportunity_history a, res_partner b
WHERE b.partner_id =a.partner_id
回答by athspk
Check these:
- SELECT Data from multiple tables?(for any number of tables, not just 2)
- SQL select statement from 2 tables
检查这些：
-从多个表中选择数据？（对于任意数量的表，而不仅仅是 2 个）
-来自 2 个表的 SQL select 语句
回答by Noor
SELECT TOP (100) PRJ.tblAvoidance.Av_ID, PRJ.tblAvoidance.Project_ID, PRJ.tblNDCProjects.Title, PRJ.tblAvoidance.Activity_Year, PRJ.tblAvoidance.CO2, PRJ.tblAvoidance.CH4, PRJ.tblAvoidance.N2O, PRJ.tblAvoidance.Updated_By, PRJ.tblAvoidance.Updated_On FROM PRJ.tblAvoidance INNER JOIN PRJ.tblNDCProjects ON PRJ.tblAvoidance.Project_ID = PRJ.tblNDCProjects.ID
SELECT TOP (100) PRJ.tblAvoidance.Av_ID、PRJ.tblAvoidance.Project_ID、PRJ.tblNDCProjects.Title、PRJ.tblAvoidance.Activity_Year、PRJ.tblAvoidance.CO2、PRJ.tblAvoidance.CH4、PRJ.tblAvoidance.N2O2 .Updated_By, PRJ.tblAvoidance.Updated_On FROM PRJ.tblAvoidance INNER JOIN PRJ.tblNDCProjects ON PRJ.tblAvoidance.Project_ID = PRJ.tblNDCProjects.ID
