teratail header banner
teratail header banner
質問するログイン新規登録

質問編集履歴

3

a

2020/05/23 12:13

投稿

Usama_bin_Ladin
Usama_bin_Ladin

スコア1

title CHANGED
File without changes
body CHANGED
@@ -6,7 +6,7 @@
6
6
  ```SQL
7
7
  SELECT
8
8
  OWNER.ID,
9
- OWNER.DOG_ID,
9
+ OWNER.PET_ID,
10
10
  CASE DOG.ID
11
11
  WHEN NULL THEN OWNER.UPDATED_AT
12
12
  ELSE DOG.UPDATED_AT

2

2020/05/23 12:13

投稿

Usama_bin_Ladin
Usama_bin_Ladin

スコア1

title CHANGED
File without changes
body CHANGED
@@ -6,7 +6,7 @@
6
6
  ```SQL
7
7
  SELECT
8
8
  OWNER.ID,
9
- OWNER.OWNER_ID,
9
+ OWNER.DOG_ID,
10
10
  CASE DOG.ID
11
11
  WHEN NULL THEN OWNER.UPDATED_AT
12
12
  ELSE DOG.UPDATED_AT

1

2020/05/23 12:12

投稿

Usama_bin_Ladin
Usama_bin_Ladin

スコア1

title CHANGED
File without changes
body CHANGED
@@ -8,8 +8,8 @@
8
8
  OWNER.ID,
9
9
  OWNER.OWNER_ID,
10
10
  CASE DOG.ID
11
- WHEN NULL THEN DOG.UPDATED_AT
11
+ WHEN NULL THEN OWNER.UPDATED_AT
12
- ELSE OWNER.UPDATED_AT
12
+ ELSE DOG.UPDATED_AT
13
13
  END
14
14
  FROM
15
15
  OWNER