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