title: Add condition while using LEFT OUTER JOIN
body: <p>I have two table i want to add one condition while using LEFT OUTER JOIN</p>
  
  <pre><code>select tt.description,tt.visible,vct.currvalue 
  from tblemployee tt 
  left outer join viwcurrentemployee vct on vct.transitiontype = tt.cid
                                        and vct.employee = 63 
                                        and tt.visible = 1 
  order by tt.cid
  </code></pre>
  
  <p>i want only those record which is have visible = 1 that is true but query ignore the condition and one thing i must have to use left outer join coz i want record from left table even record not present in right table how to check the condition that i will get only those record from left table in which visible is 1</p>