回答編集履歴
2
SQLコード追記
test
CHANGED
|
@@ -20,7 +20,7 @@
|
|
|
20
20
|
| 2 | いいい |
|
|
21
21
|
|
|
22
22
|
**[person]**
|
|
23
|
-
|person_
|
|
23
|
+
|person_id | name | tel | mail |
|
|
24
24
|
|---|---|---|---|
|
|
25
25
|
| A | yamada | 080-xx | xxx@tera.co.jp |
|
|
26
26
|
| B | fujita | 080-xx | xxx@tera.co.jp |
|
|
@@ -37,3 +37,12 @@
|
|
|
37
37
|
| 2 | A | 2 |
|
|
38
38
|
| 2 | B | 3 |
|
|
39
39
|
|
|
40
|
+
```sql
|
|
41
|
+
SELECT
|
|
42
|
+
group.group_id,
|
|
43
|
+
person.*
|
|
44
|
+
FROM
|
|
45
|
+
[group]
|
|
46
|
+
INNER JOIN group_Menber ON group.group_id = group_Menber.group_id
|
|
47
|
+
INNER JOIN person ON group_Menber.person_id = person.person_id;
|
|
48
|
+
```
|
1
質問内容の変更に伴い回答の追記
test
CHANGED
|
@@ -8,3 +8,32 @@
|
|
|
8
8
|
INNER JOIN person as b ON [group].order2 = b.id
|
|
9
9
|
INNER JOIN person as c ON [group].order3 = c.id;
|
|
10
10
|
```
|
|
11
|
+
|
|
12
|
+
---
|
|
13
|
+
正規化する場合のテーブル設計の一例
|
|
14
|
+
|
|
15
|
+
**[group]**
|
|
16
|
+
|
|
17
|
+
| group_id | group_name |
|
|
18
|
+
|---|---|
|
|
19
|
+
| 1 | あああ |
|
|
20
|
+
| 2 | いいい |
|
|
21
|
+
|
|
22
|
+
**[person]**
|
|
23
|
+
|person_ id | name | tel | mail |
|
|
24
|
+
|---|---|---|---|
|
|
25
|
+
| A | yamada | 080-xx | xxx@tera.co.jp |
|
|
26
|
+
| B | fujita | 080-xx | xxx@tera.co.jp |
|
|
27
|
+
| C | ito | 080-xx | xxx@tera.co.jp |
|
|
28
|
+
|
|
29
|
+
**[group_Menber]**
|
|
30
|
+
|
|
31
|
+
| group_id | person_id | order_num |
|
|
32
|
+
|---|---|---|
|
|
33
|
+
| 1 | A | 1 |
|
|
34
|
+
| 1 | B | 2 |
|
|
35
|
+
| 1 | C | 3 |
|
|
36
|
+
| 2 | C | 1 |
|
|
37
|
+
| 2 | A | 2 |
|
|
38
|
+
| 2 | B | 3 |
|
|
39
|
+
|