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