SELECT Name FROM Projects WHERE Code NOT IN (SELECT Project FROM AssignedTo)
Select the project names which are not assigned yet.
SELECT Name FROM Projects WHERE Code NOT IN ( SELECT Project FROM AssignedTo )
select name from projects where code not in ( select project from assignedto )
Select the project names which are not assigned yet .