我如何合并这个查询，使它只返回一列?

Question

我有以下表格:

Player Name         Nationality
--------------------------------
Romelu Lukaku       Belgian
Christian Pulisic   American
Kai Havertz         German
Masoun Mount        British
Reece James         British
Edouard Mendy       French
N'Golo Kante        French
Hakim Ziyech        Morrocan
Timo Werner         German
Thiago Silva        Brazilian
Ross Barkley        British

我尝试了以下查询:

SELECT 
REPLACE([Player Name], 'Reece', 'John'),
REPLACE([Player Name], 'Christian', 'Chris') 
FROM 
Players

这个查询返回两列而不是一列。我如何使查询一个，以便只返回一列?

Answer 1

您可以使用UNION来垂直连接行

SELECT REPLACE([Player Name], 'Reece', 'John') as name FROM Players
UNION
SELECT REPLACE([Player Name], 'Christian', 'Chris') FROM Players