[nimesh]

Yes you can get that,

SELECT Project.*
  FROM Project LEFT OUTER JOIN Completed_Project 
    ON Project.Project_ID = Completed_Project.Project_ID
 WHERE Completed_Project.Outcome IS NULL;