View difference between Paste ID: LwKvNZ9R and J8iHjM5P
SHOW: | | - or go back to the newest paste.
1-
SELECT
1+
SELECT l.*
2-
  d.DEP_NAME, sq.LAB_CNT
2+
FROM   LABORING l
3-
FROM DEPARTAMENT d, 
3+
LEFT JOIN LABORING b on (b.LAB_ID = l.LAB_BOSS_ID AND b.DEP_ID = l.DEP_ID)
4-
4+
WHERE  b.LAB_ID IS NULL