Yes you can get that,

Code: SQL
SELECT Project.*
  FROM Project LEFT OUTER JOIN Completed_Project
    ON Project.Project_ID = Completed_Project.Project_ID
 WHERE Completed_Project.Outcome IS NULL;
Assi9 like this