Just a single table with 3 columns (name,project,hours), the following works fine, but is there a better way to right this?
SELECT DISTINCT name FROM WorksOn a
WHERE NOT EXISTS
(SELECT * FROM WorksOn b
WHERE b.name = 'Smith' AND NOT EXISTS
(SELECT * FROM WorksOn c
WHERE a.name = c.name AND
c.project = b.project AND c.hours = b.hours))
Last Wiki Answer Submitted: October 26, 2012 4:41 am by testaduro55 pts.