SELECT 
  DISTINCT * 
FROM 
  TABLE_A as A, 
  TABLE_B as B 
WHERE 
  A.ID = B.ID and 
  A.SECONDCOLUMN != B.SECONDCOLUMN

##</code><code>##

SELECT
   COUNT(*)
FROM 
  (  
    SELECT ID, COUNT(*) AS CNT FROM TABLE_A GROUP BY ID
  ) as COUNTS
WHERE
  CNT = 1