SELECT Name FROM Projects WHERE NOT Code IN (SELECT Project FROM AssignedTo)
Pilih nama proyek yang belum ditetapkan.
CREATE TABLE Projects (Name VARCHAR, Code VARCHAR, Project VARCHAR); CREATE TABLE AssignedTo (Name VARCHAR, Code VARCHAR, Project VARCHAR)