sql - 我的 PSQL View 表有什么问题？

Question

我有两张牌 table 玩家和比赛:

CREATE TABLE player(
id serial PRIMARY KEY NOT NULL,
name varchar(255) NOT NULL
);

CREATE TABLE match(
id serial PRIMARY KEY,
winner serial REFERENCES player(id) NOT NULL,
loser serial REFERENCES player(id) NOT NULL CHECK (loser != winner)
);

CREATE SEQUENCE playerid_sequence
start 1
increment 1;

CREATE SEQUENCE matchid_sequence
start 1
increment 1;

我想创建一个连接两个表的 View 表:

CREATE VIEW matchplayers AS
SELECT winner.name, loser.name, m.id 
from player winner, player loser, match m
WHERE m.winner = winner.id AND m.loser = loser.id;

但它返回一个错误，“名称”已被多次提及。对 SQL 相当缺乏经验

Answer 1

尝试

CREATE VIEW matchplayers AS
SELECT winner.name as winner_name, loser.name as loser_name, m.id 
from player winner, player loser, match m
WHERE m.winner = winner.id AND m.loser = loser.id;

获取 View 的明确列名。