Grabbing Accounts That Doesnt Have All Possible Values

I have a table:


Code:


serverid | value
12 | languages
12 | php
12 | coldfusion
12 | mysql
12 | mssql
12 | asp
14 | languages
14 | php
14 | asp
16 | languages
16 | php
16 | coldfusion
16 | mysql
16 | mssql
15 | languages
15 | coldfusion
15 | mssql



i need to get all serverid of those that have entries for "languages", but dont have rows for php, asp, and coldfusion.

so in the above example, i would get 15 and 16.

i dont think i can do in one statement?


sql Code:






Original
- sql Code




SELECT t.serverid FROM table t WHERE t.value = 'languages' AND (t.value != 'php' AND t.value != 'asp' AND t.value !='coldfusion')






SELECT t.serverid FROM TABLE t WHERE t.value = 'languages' AND (t.value != 'php' AND t.value != 'asp' AND t.value !='coldfusion')



i think that above statement is completely wrong already ( I think it would need to do a select statement inside the WHERE clause)

i think i would need to maybe create a temp table and use a cursor?

any ideas or help ?