回答編集履歴
1
SQL文を修正
answer
CHANGED
|
@@ -17,7 +17,7 @@
|
|
|
17
17
|
FROM TBL1
|
|
18
18
|
INNER JOIN TBL2 ON TBL2.ID = TBL1.ID
|
|
19
19
|
WHERE TBL1.DEPTID IN (1021,1025) AND TBL2.HIREDATE IS NOT NULL
|
|
20
|
-
GROUP BY TBL1.SHOPID
|
|
20
|
+
GROUP BY TBL1.SHOPID, TBL1.NAME
|
|
21
21
|
HAVING COUNT(*) > 0
|
|
22
22
|
ORDER BY TBL1.SHOPID
|
|
23
23
|
```
|