What do you want as output? this?

Code:
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:
Code: sql
SELECT Project.*
     , Completed_Project.Outcome
  FROM Project LEFT JOIN Completed_Project
    ON Project.Project_ID = Completed_Project.Project_ID;

Last edited by nimesh; 24Oct2009 at 23:22.. Reason: modified code block
Assi9 like this