blocks|key|2018335|text|我认为你需要知道Sql_Join是如何工作的。在W3Schools上你可以找到有用的例子。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2018336|一个简单的例子：|2018337|SELECT+Persons.LastName,+Persons.FirstName,+Orders.OrderNo
FROM+Persons
INNER+JOIN+Orders
ON+Persons.P_Id=Orders.P_Id
ORDER+BY+Persons.LastName|code-block|syntax|javascript|2018338|2018339|编辑|style|BOLD|2018340|您可以尝试如下所示：|2018341|SELECT+*+FROM+tableA+
inner+join+tableB+on+tableA.term_id+=+tableB.term_id+
inner+join+tableC+on+tableA.term_id+=+tableC.term_id;|2018342|这是一个你可以根据需要修改的例子。|2018343|2018344|编辑2|2018345|SELECT+*+FROM++tableB+
JOIN+tableA+AS+tableA1+ON+tableB.term_id+=+tableA1.a_term_id
JOIN+tableA+AS+tableA2+ON+tableB.term_id+=+tableA2.b_term_id
JOIN+tableA+AS+tableA3+ON+tableB.term_id+=+tableA3.c_term_id|2018346|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/Join_%2528SQL%2529|1|http://www.w3schools.com/sql/sql_join.asp^0|8|8|0|O|9|1|0|0|0|0|0|2|0|0|0|0|0|0|3|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@$A|1B|B|1C|1|1D]|$A|1E|B|1F|1|1G]]|C|$]]|$1|D|3|E|5|6|7|1H|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|1I|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|1J|8|@]|9|@]|C|$]]|$1|L|3|M|5|6|7|1K|8|@$A|1L|B|1M|N|O]]|9|@]|C|$]]|$1|P|3|Q|5|6|7|1N|8|@]|9|@]|C|$]]|$1|R|3|S|5|H|7|1O|8|@]|9|@]|C|$I|J]]|$1|T|3|U|5|6|7|1P|8|@]|9|@]|C|$]]|$1|V|3|-4|5|6|7|1Q|8|@]|9|@]|C|$]]|$1|W|3|X|5|6|7|1R|8|@$A|1S|B|1T|N|O]]|9|@]|C|$]]|$1|Y|3|Z|5|H|7|1U|8|@]|9|@]|C|$I|J]]|$1|10|3|-4|5|6|7|1V|8|@]|9|@]|C|$]]]|11|$12|$5|13|14|15|C|$16|17]]|18|$5|13|14|15|C|$16|19]]]]

I think you need to know how <a href="http://en.wikipedia.org/wiki/Join_%28SQL%29" rel="nofollow">Sql_Join</a> works. Here on <a href="http://www.w3schools.com/sql/sql_join.asp" rel="nofollow">W3Schools</a> you can find useful examples.

A simple example:

<pre><code>SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo
FROM Persons
INNER JOIN Orders
ON Persons.P_Id=Orders.P_Id
ORDER BY Persons.LastName
</code></pre>

<hr>

EDIT

You can try something like this:

<pre><code>SELECT * FROM tableA 
inner join tableB on tableA.term_id = tableB.term_id 
inner join tableC on tableA.term_id = tableC.term_id;
</code></pre>

It an example you can modify as per your need.

<hr>

Edit 2

<pre><code>SELECT * FROM tableB 
JOIN tableA AS tableA1 ON tableB.term_id = tableA1.a_term_id
JOIN tableA AS tableA2 ON tableB.term_id = tableA2.b_term_id
JOIN tableA AS tableA3 ON tableB.term_id = tableA3.c_term_id
</code></pre>

blocks|key|2366495|text|下面是一个例子。假设我们有两个表-+Employees和Companies：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2366496|CREATE+TABLE+Employees(
+++Id+int,
+++Name+varchar(128),
+++CompanyId+int);

CREATE+TABLE+Companies(+
+++Id+int,
+++Name+varchar(128),
+++Address+varchar(1024),
+++DateFounded+datetime);+|code-block|syntax|javascript|2366497|下面的SQL查询将联接这些表：|2366498|SELECT+*+FROM+Employees++
++++INNER+JOIN+Companies+
++++ON+Employees.CompanyId+=+Companies.Id|2366499|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Here is an example. Suppose that we have two tables - Employees and Companies:

<pre><code>CREATE TABLE Employees(
 Id int,
 Name varchar(128),
 CompanyId int);

CREATE TABLE Companies( 
 Id int,
 Name varchar(128),
 Address varchar(1024),
 DateFounded datetime); 
</code></pre>

The following SQL query will join the tables:

<pre><code>SELECT * FROM Employees 
 INNER JOIN Companies 
 ON Employees.CompanyId = Companies.Id
</code></pre>

blocks|key|398079|text|您的问题有点不清楚，但我猜您的表A有三个字段，每个字段标识表B的一行(可能不同)。您希望根据表A的单个行的字段值从表B的每一行检索信息。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|398080|为此，您需要将表A连接到表B三次，表A的每个字段对应一次。每个连接都应该被赋予一个别名，然后您可以通过限定的字段名来引用连接的表中的字段。|398081|SELECT+b1.info,+b2.info,+b3.info
FROM+++A+JOIN+B+AS+b1+ON+field1+=+b1.field
+++++++++JOIN+B+AS+b2+ON+field2+=+b2.field
+++++++++JOIN+B+AS+b3+ON+field3+=+b2.field
WHERE++...|code-block|syntax|javascript|398082|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Your question is a bit unclear, but I'll guess that you have a table A with three fields, each of which identifies a (possibly different) row from table B. You want to retrieve info from each of those rows of table B based on the field values of a single row of table A.

To do this, you will need to join table A to table B three times, once for each field of table A. Each join should be given an alias and then you can refer to the fields in the joined table by qualified field names.

<pre><code>SELECT b1.info, b2.info, b3.info
FROM A JOIN B AS b1 ON field1 = b1.field
 JOIN B AS b2 ON field2 = b2.field
 JOIN B AS b3 ON field3 = b2.field
WHERE ...
</code></pre>

blocks|key|4091851|text|SELECT+
t.a_term_id,+a.term_title,+a.term_description,+
t.b_term_id,+b.term_title,+b.term_description,
t.c_term_id,+c.term_title,+c.term_description
FROM+abc_terms+t+JOIN+(+terms_info+a,+terms_info+b,+terms_info+c+)
ON+(+t.a_term_id+=+a.term_id+
AND+t.b_term_id+=+b.term_id+
AND+t.c_term_id+=+c.term_id+)|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|4091852|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SELECT 
t.a_term_id, a.term_title, a.term_description, 
t.b_term_id, b.term_title, b.term_description,
t.c_term_id, c.term_title, c.term_description
FROM abc_terms t JOIN ( terms_info a, terms_info b, terms_info c )
ON ( t.a_term_id = a.term_id 
AND t.b_term_id = b.term_id 
AND t.c_term_id = c.term_id )
</code></pre>

There are three fields in a table, all of them refer the same field in another table, like this:

<pre><code>table1
-------
! a_term_id* ! b_term_id* ! c_term_id* !
! ! ! !

table2
-------

! term_id ! term_title ! term_description !
! ------- ! ! !
</code></pre>

columns a_term_id, b_term_id, c_term_id all refer to term_id

How should I write the SQL statement to retrieve the three fields' info?

How to write the right SQL query statement using join condition?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

一个表中有三个字段，它们都引用另一个表中的相同字段，如下所示：table1-------! a_term_id* ! b_term_id* ! c_term_id* !!            !            !            !table2-------! term_id ! term_title ...

问如何使用join条件编写正确的SQL查询语句？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用join条件编写正确的SQL查询语句？EN