回答編集履歴
3
update
answer
CHANGED
|
@@ -15,7 +15,7 @@
|
|
|
15
15
|
|
|
16
16
|
WHERE句のCASEにて、こんな書き方できるんですね。
|
|
17
17
|
```sql
|
|
18
|
-
SELECT * FROM tbl_products AS a,
|
|
18
|
+
SELECT a.* FROM tbl_products AS a,
|
|
19
19
|
tbl_products AS b
|
|
20
20
|
WHERE
|
|
21
21
|
CASE WHEN a.house_code is NULL THEN a.product_name = b.product_name
|
2
update
answer
CHANGED
|
@@ -13,7 +13,7 @@
|
|
|
13
13
|
order by 1;
|
|
14
14
|
```
|
|
15
15
|
|
|
16
|
-
WHERE句のCASEにて書き
|
|
16
|
+
WHERE句のCASEにて、こんな書き方できるんですね。
|
|
17
17
|
```sql
|
|
18
18
|
SELECT * FROM tbl_products AS a,
|
|
19
19
|
tbl_products AS b
|
1
update
answer
CHANGED
|
@@ -11,4 +11,16 @@
|
|
|
11
11
|
union all
|
|
12
12
|
select name_tbl.* from name_tbl left join house_tbl using(product_id) where house_tbl.product_id is null
|
|
13
13
|
order by 1;
|
|
14
|
+
```
|
|
15
|
+
|
|
16
|
+
WHERE句のCASEにて書きました
|
|
17
|
+
```sql
|
|
18
|
+
SELECT * FROM tbl_products AS a,
|
|
19
|
+
tbl_products AS b
|
|
20
|
+
WHERE
|
|
21
|
+
CASE WHEN a.house_code is NULL THEN a.product_name = b.product_name
|
|
22
|
+
ELSE a.house_code = b.house_code
|
|
23
|
+
END
|
|
24
|
+
AND a.create_date>b.create_date
|
|
25
|
+
;
|
|
14
26
|
```
|