回答編集履歴
1
修正
test
CHANGED
|
@@ -11,8 +11,6 @@
|
|
|
11
11
|
FROM table_eigyou AS t1 left JOIN table_shain AS t2
|
|
12
12
|
|
|
13
13
|
ON t1.shainbangou1 = t2.bangou
|
|
14
|
-
|
|
15
|
-
WHERE eigyouday BETWEEN '2017-04-01' AND '2018-03-31'
|
|
16
14
|
|
|
17
15
|
GROUP BY shainbangou1,shain,shozoku, DATE_FORMAT(date_sub(eigyouday, INTERVAL 3 MONTH),'%Y')
|
|
18
16
|
|