SELECT Name FROM Projects WHERE Code NOT IN (SELECT Project FROM AssignedTo)
What are the names of projects that have not been assigned?
SELECT Name FROM Projects WHERE Code NOT IN ( SELECT Project FROM AssignedTo )
select name from projects where code not in ( select project from assignedto )
What are the names of projects that have not been assigned ?