回答編集履歴

1

訂正

2020/08/27 09:37

投稿

sazi
sazi

スコア25329

test CHANGED
@@ -4,7 +4,7 @@
4
4
 
5
5
  select kokyaku_id
6
6
 
7
- , case when 1 in (mail, directmail) then 1 else 0 end
7
+ , case when mail=1 and directmail=1 then 1 else 0 end
8
8
 
9
9
  from datalab
10
10