[nimesh]

What do you want as output? this?

Project ID Project Name           Outcome
1          Business Plan          Success
2          Software Design        Success
3          Schedule Program       Success
4          Feasibility Study RE            
5          Website Development RE

If yes, then what you are looking for is called Left Outer Join

and here is the query:

SELECT Project.*
     , Completed_Project.Outcome
  FROM Project LEFT JOIN Completed_Project 
    ON Project.Project_ID = Completed_Project.Project_ID;