CREATE TABLE AssignedTo (Name VARCHAR, Code VARCHAR, Project VARCHAR)
CREATE TABLE Projects (Name VARCHAR, Code VARCHAR, Project VARCHAR)

Select the project names which are not assigned yet.
SELECT Name FROM Projects WHERE NOT Code IN (SELECT Project FROM AssignedTo)
SELECT "Name" FROM "Projects" WHERE NOT "Code" IN (SELECT "Project" FROM "AssignedTo")