title: Comparing two columns from different tables of different types in SQL
body: <p>There is a column that exists in 2 tables. In table 1, this column contains values in binary form (<code>int</code>), <code>1</code> and <code>0</code>, while the other table contains the column in form <code>'Y'</code> and <code>'N'</code>. </p>
  
  <p>Essentially I need to display rows in table 1 that contain values that are different from values in table 2 for that column. How do I compute 1 to Y and 0 to N for comparison? </p>
  
  <p>Example:</p>
  
  <p>Table 1: </p>
  
  <pre><code>DateRecorded SchoolName StudentName isAbsent hasPassed
  ------------ ---------- ----------- -------- ---------
  2011-04-03   ABC        John        Y        Y
  2011-04-05   ABC        John        N        Y 
  </code></pre>
  
  <p>Table 2: </p>
  
  <pre><code>DateRecorded SchoolName StudentName isAbsent hasPassed
  ------------ ---------- ----------- -------- ---------
  2011-04-03   ABC        John        0        1
  2011-04-05   ABC        John        0        1
  </code></pre>
  
  <p>Should return row:</p>
  
  <pre><code>2011-04-03   ABC        John        Y        Y
  </code></pre>
  
  <p>from Table 1 as this row is conflicting with the same row in Table 2.</p>