2021-05-05 10:13:49 -07:00
|
|
|
|
---
|
|
|
|
|
id: 5e7b9f180b6c005b0e76f08f
|
2021-07-02 18:45:29 +05:30
|
|
|
|
title: '關係數據庫:聯接操作'
|
2021-05-05 10:13:49 -07:00
|
|
|
|
challengeType: 11
|
|
|
|
|
videoId: jvDw3D9GKac
|
2021-10-03 12:24:27 -07:00
|
|
|
|
bilibiliIds:
|
|
|
|
|
aid: 804461215
|
|
|
|
|
bvid: BV1Ry4y1j7tv
|
|
|
|
|
cid: 377542880
|
2021-05-05 10:13:49 -07:00
|
|
|
|
dashedName: relational-databases-join-operation
|
|
|
|
|
---
|
|
|
|
|
|
|
|
|
|
# --question--
|
|
|
|
|
|
|
|
|
|
## --text--
|
|
|
|
|
|
2021-07-02 18:45:29 +05:30
|
|
|
|
在 SQL 語句中使用 JOIN 子句時,ON 的作用是什麼?
|
2021-05-05 10:13:49 -07:00
|
|
|
|
|
|
|
|
|
## --answers--
|
|
|
|
|
|
2021-07-02 18:45:29 +05:30
|
|
|
|
它指示在哪些表上執行 JOIN。
|
2021-05-05 10:13:49 -07:00
|
|
|
|
|
|
|
|
|
---
|
|
|
|
|
|
2021-07-02 18:45:29 +05:30
|
|
|
|
它指定用於 JOIN 的字段。
|
2021-05-05 10:13:49 -07:00
|
|
|
|
|
|
|
|
|
---
|
|
|
|
|
|
2021-07-02 18:45:29 +05:30
|
|
|
|
它指示如何將兩個表連接在一起。
|
2021-05-05 10:13:49 -07:00
|
|
|
|
|
|
|
|
|
## --video-solution--
|
|
|
|
|
|
|
|
|
|
3
|
|
|
|
|
|