What i would like to do is to list all users apart from those who's department = no longer employed

guido2004
—
2013-11-14T12:12:27Z —
#2

So, select all rows from the table where the department is not 'no longer employed'I'm sure it won't be too hard to translate that in SQL. Give it a try, and if you can't get it to work, post your query here.