title: How do I put condition on a particular column after i joined two tables
body: <p>I joined two tables to get two columns by using code:</p>
  
  <pre><code>SELECT rpt_Line_Shift_AvailableHrs.LineNumber
        ,rpt_Line_Shift_Prod.ShiftNumber
  FROM rpt_Line_Shift_AvailableHrs
  LEFT OUTER JOIN rpt_Line_Shift_Prod 
  ON rpt_Line_Shift_AvailableHrs.LineNumber=rpt_Line_Shift_Prod.LineNumber 
  </code></pre>
  
  <p>the result I get is:</p>
  
  <pre><code>Line#    , ShiftNumber
  1            A
  1            A
  1            B
  1            C
  1            C
  1            C
  1            D
  </code></pre>
  
  <p>but I'm looking for a result like this </p>
  
  <pre><code>Line# ,    ShiftNumber
  1            A
  1            B
  1            C
  1            D
  </code></pre>