title: How to write sub query with where Condition and match the columns values
body: <p>the following is my query </p>
  
  <pre><code>select * from tbl_incometax_master where (select Slabtitle=Gender,SlabSubTitle=Senior_CTZN_Type FROM etds.dbo.tbl_Employee_Master WHERE employee_id = 1218  AND company_id = 1987)
  </code></pre>
  
  <p>when try to execute got following error in sql server 2008 r2 :
  Msg 4145, Level 15, State 1, Line 2
  An expression of non-boolean type specified in a context where a condition is expected, near ')'.</p>