嗨Jason，

Hi Jason,

我'我不确定UNION查询会这样做。我想也许你需要查询每个查询的DISTINCT患者标识符。然后，您可以使用唯一标识符列表来计算您的计数。

I'm not sure a UNION query will do it. I think maybe you'll need a query of DISTINCT patient identifier for each query. Then, you can use the list of unique identifiers to do your counts.

只需要我的2美分......

Just my 2 cents...