質問編集履歴

2

sql確認、追記中

2018/02/13 14:16

投稿

TakefusaBoku
TakefusaBoku

スコア41

test CHANGED
File without changes
test CHANGED
@@ -40,17 +40,29 @@
40
40
 
41
41
  SELECT
42
42
 
43
-
43
+ A1,
44
44
 
45
-
45
+ A2,
46
46
 
47
-
47
+ A3
48
+
49
+ B1,
50
+
51
+ B2,
52
+
53
+ B3,
54
+
55
+ C1,
56
+
57
+ C2,
58
+
59
+ C3
48
60
 
49
61
  FROM
50
62
 
51
- Aテーブル inner join Bテーブル on A1 = B1
63
+ TableA inner join TableB on TableA.A1 = TableB.B1
52
64
 
53
- Aテーブル inner join Cテーブル on A3 = C1
65
+ TableA inner join TableC on TableA.A3 = TableC.C1
54
66
 
55
67
 
56
68
 

1

SQL追加

2018/02/13 14:16

投稿

TakefusaBoku
TakefusaBoku

スコア41

test CHANGED
File without changes
test CHANGED
@@ -61,3 +61,39 @@
61
61
 
62
62
 
63
63
  ```
64
+
65
+
66
+
67
+ ```ここに言語を入力
68
+
69
+ create table tableA (
70
+
71
+ A1 int primary key,
72
+
73
+ A2 varchar(80),
74
+
75
+ A3 int
76
+
77
+ );
78
+
79
+ create table tableB (
80
+
81
+ B1 int primary key,
82
+
83
+ B2 varchar(80),
84
+
85
+ B3 varchar(80)
86
+
87
+ );
88
+
89
+ create table tableC (
90
+
91
+ C1 int primary key,
92
+
93
+ C2 varchar(80),
94
+
95
+ C3 varchar(80)
96
+
97
+ );
98
+
99
+ ```