freeCodeCamp/curriculum/challenges/chinese-traditional/07-scientific-computing-with-python/python-for-everybody/relational-databases-join-operation.md

---
id: 5e7b9f180b6c005b0e76f08f
title: '關係數據庫：聯接操作'
challengeType: 11
videoId: jvDw3D9GKac
bilibiliIds:
  aid: 804461215
  bvid: BV1Ry4y1j7tv
  cid: 377542880
dashedName: relational-databases-join-operation
---

# --question--

## --text--

在 SQL 語句中使用 JOIN 子句時，ON 的作用是什麼？

## --answers--

它指示在哪些表上執行 JOIN。

---

它指定用於 JOIN 的字段。

---

它指示如何將兩個表連接在一起。

## --video-solution--

3
-												chore: seed chinese traditional (#42005)

Seeds the chinese traditional files manually so we can deploy to
staging.
											
										
										
											2021-05-05 10:13:49 -07:00
+								---
 								id: 5e7b9f180b6c005b0e76f08f
-												chore(i18n,curriculum): processed translations (#42721)


											
										
										
											2021-07-02 18:45:29 +05:30
+								title: '關係數據庫：聯接操作'
-												chore: seed chinese traditional (#42005)

Seeds the chinese traditional files manually so we can deploy to
staging.
											
										
										
											2021-05-05 10:13:49 -07:00
+								challengeType: 11
 								videoId: jvDw3D9GKac
-												chore(i18n,curriculum): update translations (#43661)


											
										
										
											2021-10-03 12:24:27 -07:00
+								bilibiliIds:
 								  aid: 804461215
 								  bvid: BV1Ry4y1j7tv
 								  cid: 377542880
-												chore: seed chinese traditional (#42005)

Seeds the chinese traditional files manually so we can deploy to
staging.
											
										
										
											2021-05-05 10:13:49 -07:00
+								dashedName: relational-databases-join-operation
 								---
 								# --question--
 								## --text--
-												chore(i18n,curriculum): processed translations (#42721)


											
										
										
											2021-07-02 18:45:29 +05:30
+								在 SQL 語句中使用 JOIN 子句時，ON 的作用是什麼？
-												chore: seed chinese traditional (#42005)

Seeds the chinese traditional files manually so we can deploy to
staging.
											
										
										
											2021-05-05 10:13:49 -07:00
 								## --answers--
-												chore(i18n,curriculum): processed translations (#42721)


											
										
										
											2021-07-02 18:45:29 +05:30
+								它指示在哪些表上執行 JOIN。
-												chore: seed chinese traditional (#42005)

Seeds the chinese traditional files manually so we can deploy to
staging.
											
										
										
											2021-05-05 10:13:49 -07:00
 								---
-												chore(i18n,curriculum): processed translations (#42721)


											
										
										
											2021-07-02 18:45:29 +05:30
+								它指定用於 JOIN 的字段。
-												chore: seed chinese traditional (#42005)

Seeds the chinese traditional files manually so we can deploy to
staging.
											
										
										
											2021-05-05 10:13:49 -07:00
 								---
-												chore(i18n,curriculum): processed translations (#42721)


											
										
										
											2021-07-02 18:45:29 +05:30
+								它指示如何將兩個表連接在一起。
-												chore: seed chinese traditional (#42005)

Seeds the chinese traditional files manually so we can deploy to
staging.
											
										
										
											2021-05-05 10:13:49 -07:00
 								## --video-solution--