質問編集履歴
1
訂正、加筆
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -2,6 +2,29 @@
|
|
|
2
2
|
|
|
3
3
|
3つのテーブルをid=1 を条件にして結合させたいです。valueの格納庫数が最も多いものに合わせたいです
|
|
4
4
|
|
|
5
|
+
```SQL
|
|
6
|
+
CREATE TABLE `example`.`tablea` (
|
|
7
|
+
`id` INT NOT NULL,
|
|
8
|
+
`avalue` VARCHAR(45) NOT NULL,
|
|
9
|
+
PRIMARY KEY (`id`));
|
|
10
|
+
|
|
11
|
+
CREATE TABLE `example`.`tableb` (
|
|
12
|
+
`id` INT NOT NULL,
|
|
13
|
+
`bvalue` VARCHAR(45) NOT NULL,
|
|
14
|
+
PRIMARY KEY (`id`));
|
|
15
|
+
|
|
16
|
+
CREATE TABLE `example`.`tablec` (
|
|
17
|
+
`id` INT NOT NULL,
|
|
18
|
+
`bvalue` VARCHAR(45) NOT NULL,
|
|
19
|
+
PRIMARY KEY (`id`));
|
|
20
|
+
|
|
21
|
+
INSERT INTO `example`.`tablea` (`id`, `avalue`) VALUES ('1', 'a');
|
|
22
|
+
INSERT INTO `example`.`tableb` (`id`, `bvalue`) VALUES ('1', 'b');
|
|
23
|
+
INSERT INTO `example`.`tableb` (`id`, `bvalue`) VALUES ('2', 'bb');
|
|
24
|
+
INSERT INTO `example`.`tablec` (`id`, `cvalue`) VALUES ('1', 'c');
|
|
25
|
+
INSERT INTO `example`.`tablec` (`id`, `cvalue`) VALUES ('1', 'cc');
|
|
26
|
+
INSERT INTO `example`.`tablec` (`id`, `cvalue`) VALUES ('1', 'ccc');
|
|
27
|
+
```
|
|
5
28
|
table A
|
|
6
29
|
|id|avalue|
|
|
7
30
|
|:-|:--:|
|
|
@@ -54,7 +77,7 @@
|
|
|
54
77
|
SELECT * FROM tableA
|
|
55
78
|
join tableB on tableA.id=tableB.id
|
|
56
79
|
join tableC on tableA.id=tableC.id
|
|
57
|
-
where id =1 ;
|
|
80
|
+
where tablea.id =1 ;
|
|
58
81
|
```
|
|
59
82
|
|
|
60
83
|
### 試したこと
|