Select the project names which are not assigned yet.
CREATE TABLE Projects (Name VARCHAR, Code VARCHAR, Project VARCHAR); CREATE TABLE AssignedTo (Name VARCHAR, Code VARCHAR, Project VARCHAR)
[SQL] SELECT Name FROM Projects WHERE NOT Code IN (SELECT Project FROM AssignedTo) [/SQL]