回答編集履歴
3
update
test
CHANGED
|
@@ -32,7 +32,7 @@
|
|
|
32
32
|
|
|
33
33
|
```sql
|
|
34
34
|
|
|
35
|
-
SELECT * FROM tbl_products AS a,
|
|
35
|
+
SELECT a.* FROM tbl_products AS a,
|
|
36
36
|
|
|
37
37
|
tbl_products AS b
|
|
38
38
|
|
2
update
test
CHANGED
|
@@ -28,7 +28,7 @@
|
|
|
28
28
|
|
|
29
29
|
|
|
30
30
|
|
|
31
|
-
WHERE句のCASEにて書き
|
|
31
|
+
WHERE句のCASEにて、こんな書き方できるんですね。
|
|
32
32
|
|
|
33
33
|
```sql
|
|
34
34
|
|
1
update
test
CHANGED
|
@@ -25,3 +25,27 @@
|
|
|
25
25
|
order by 1;
|
|
26
26
|
|
|
27
27
|
```
|
|
28
|
+
|
|
29
|
+
|
|
30
|
+
|
|
31
|
+
WHERE句のCASEにて書きました
|
|
32
|
+
|
|
33
|
+
```sql
|
|
34
|
+
|
|
35
|
+
SELECT * FROM tbl_products AS a,
|
|
36
|
+
|
|
37
|
+
tbl_products AS b
|
|
38
|
+
|
|
39
|
+
WHERE
|
|
40
|
+
|
|
41
|
+
CASE WHEN a.house_code is NULL THEN a.product_name = b.product_name
|
|
42
|
+
|
|
43
|
+
ELSE a.house_code = b.house_code
|
|
44
|
+
|
|
45
|
+
END
|
|
46
|
+
|
|
47
|
+
AND a.create_date>b.create_date
|
|
48
|
+
|
|
49
|
+
;
|
|
50
|
+
|
|
51
|
+
```
|