mysql中三个表之间的内部联接 [英] Inner join between three tables in mysql

问题描述

我有3张桌子

• 公司
• 联系人
• 广告系列

联系人具有公司的外键.公司具有活动的外键.它们都具有名称"列.我需要一个联接表，其中将包含联系人姓名，公司名称和广告系列名称.

Contacts has foreign key of companies. Companies has foreign key of campaigns. All of them have a column 'name'. I need a join table which will have contact name company name and campaign name.

contact
id   name company_id
companies
id   name campaign_id
campaigns
id   name company_id

推荐答案

select con.name as contact_name , com.name as company_name,campa.name as campaign_name
from contact con inner join company com
on con.companyid = com.companyid
inner join campaign campa
on com.campaignid = campa.campaignid

假设相关表格的ID列

这篇关于mysql中三个表之间的内部联接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！