一种选择使用EXISTS:
EXISTS
SELECT a.a FROM TableA a WHERE NOT EXISTS (SELECT 1 FROM TableB b WHERE b.a = a.a);
另一种选择是进行反加入:
SELECT a.a FROM TableA a LEFT JOIN TableB b ON a.a = b.a WHERE b.a IS NULL;