回答編集履歴
2
推敲
test
CHANGED
|
@@ -16,9 +16,11 @@
|
|
|
16
16
|
|
|
17
17
|
SELECT T1.column1, coalesce(t2.column3, t3.column3)
|
|
18
18
|
|
|
19
|
-
FROM Table1 t1
|
|
19
|
+
FROM Table1 t1
|
|
20
20
|
|
|
21
|
+
left JOIN Table2 t2
|
|
22
|
+
|
|
21
|
-
ON T1.column1 = T2.column1 AND T1.column2 = T2.column2
|
|
23
|
+
ON T1.column1 = T2.column1 AND T1.column2 = T2.column2
|
|
22
24
|
|
|
23
25
|
left join (
|
|
24
26
|
|
|
@@ -38,6 +40,6 @@
|
|
|
38
40
|
|
|
39
41
|
) t3
|
|
40
42
|
|
|
41
|
-
ON T1.column1 = T3.column1
|
|
43
|
+
ON T1.column1 = T3.column1
|
|
42
44
|
|
|
43
45
|
```
|
1
推敲
test
CHANGED
|
@@ -38,4 +38,6 @@
|
|
|
38
38
|
|
|
39
39
|
) t3
|
|
40
40
|
|
|
41
|
+
ON T1.column1 = T3.column1
|
|
42
|
+
|
|
41
43
|
```
|