SELECT pk, c1 FROM ( SELECT t1.pk, t1.c1 FROM t1 UNION ALL SELECT t2.pk, t2.c1 FROM t2 ) t GROUP BY pk, c1 HAVING COUNT(*) = 1 ORDER BY pk This entry was posted in Uncategorized. Bookmark the permalink. Please Post Your Comments & ReviewsYour email address will not be published. Required fields are marked * Save my name, email, and website in this browser for the next time I comment.