title: SQL JOIN and WHERE statement
body: <p>I have a problem getting this sql statemen to return what I want:
  I want it to return a list of properties both the employee or Job_Profile. If one of them do not have the property it should return NULL in that row/column
  Now the sql looks like:</p>
  
  <pre><code>SELECT Parameter.Patameter_Description ParamName, 
         Job_Profile.Title, Job_Property.Mark JobMark, 
         Emp_Property.Mark EmpMark, 
         Emp_Id--, (Employee.First_Name + ' ' + Employee.Last_Name) EmpName
  FROM Job_Property
  INNER JOIN  Job_Profile ON Job_Profile.Title = Job_Property.Job_Title
  INNER JOIN Parameter ON Job_Property.Parameter_Id = Parameter.Id
  RIGHT JOIN Emp_Property ON Emp_Property.Parameter_Id = Job_Property.Parameter_Id
  INNER JOIN Employee ON Emp_Property.Emp_Id = Employee.Enterprise_Staff_Id
  
  WHERE Employee.Enterprise_Staff_Id = 22 
  AND Job_Profile.Title = 
      (SELECT 
         Employee.Job_Profile_Name 
         FROM Employee WHERE Employee.Enterprise_Staff_Id = 22)
  </code></pre>
  
  <p>The result is:</p>
  
  <pre><code>Analyse test    1   3   22
  </code></pre>
  
  <p>And I would like it to be something like this:</p>
  
  <pre><code>Analyse     test     1      3       22
  
  Data        test     3      NULL    NULL or 22
  
  economic    test     4      NULL    NULL or 22
  
  Service     test     2      NULL    NULL or 22
  </code></pre>
  
  <p>I know there is a problem when I: 
   - join Emp_Property
   - Make the WHERE statement</p>