Access联合查询

Question

我是新手访问，需要一些帮助，我已经创建了一个名为FE的联合查询，并希望该联合查询FE只查看2 columns...Now当我运行FE查询时，我看到“县，VoteCount总数”这2列，我可以看到所有列，我不想在FE联合查询中查看。请帮帮忙..。Output of below code... However, I want only 2 columns

我在FE中的SQL代码是

Select County, [Total Of VoteCount],  * From AGC
UNION ALL 
Select County, [Total Of VoteCount], *From CBC;

FE is the Union Query that I created using AGC and CBC Query

Answer 1

星号符号*在SQL语言中的意思是全部。因此，在联合之前，从两个查询中删除*。请在下面尝试。

Select County, [Total Of VoteCount] From AGC
UNION ALL 
Select County, [Total Of VoteCount] From CBC;