2008-08-06 except SQL 差集合。使ったことがありません。Oracleの場合はminus。 SELECT EmployeeName FROM Employees EXCEPT SELECT e.EmployeeName FROM Sales AS s JOIN Employees AS e ON s.EmployeeID = e.EmployeeID ;