UNION 的各个部分作为单独的查询处理，因此您可以将它们分组在子查询中:

The parts of a UNION are handled as separate queries, so you can group them in a subquery:

SELECT Name 
FROM (Select Name from Fname
      UNION ALL
      Select Name from Lname)sub
WHERE Name NOT IN (Select Name from Exceptions)

如果您不关心重复，您可以将其保留为 UNION ALL.

You can keep that as UNION ALL if you don't care about duplicates.