title: How do you determine the records included in Table A and not in Table B
body: <p>I have two SQL (Azure SqlDB) tables, Table A and Table B. Each table share the P_Code column.  Table A has 600 records and Table B has 400 matching (A.P_Code = B.P_Code).  </p>
  
  <p>I'm interested in seeing the 200 records in A and not in B. I have tried the following two queries, but neither returns any results.   Where am I going wrong. </p>
  
  <pre><code>Select A.* From 
  [Table A]A 
  FULL OUTER JOIN
  [Table B]B
  ON A.P_CODE = B.P_CODE
  WHERE B.P_CODE IS NULL
  
  Select A.* From 
  [TABLE A] A 
  LEFT JOIN
  [TABLE B] B
  ON A.P_CODE = B.P_CODE
  WHERE B.P_CODE IS NULL
  </code></pre>