主页 / user-567177

ia_prosto_coder's questions

Martin Hope
ia_prosto_coder
Asked: 2023-09-19 17:21:11 +0000 UTC
  • 5

有一个员工表，其中有一个 fio 字段。文本。结果表中有字段sender_id 和receiver_id。两者都是整数。当尝试创建视图时

CREATE VIEW "problem_list_view" AS 
select problem_list.id,
        problem_list.date_start,
        users.fio as fio_sender,
        problem_list.problem_text,
        problem_list.solution_text,
        users.fio as fio_reciever,
        problem_list.date_end,
        statuses.name as status
from problem_list
left JOIN users on problem_list.sender_id = users.id
left join users on problem_list.receiever_id = users.id
left join statuses on problem_list.status_id = statuses.id

我得到错误模糊列名： And this is clear to me, sql indicates ambiguity. 我在结果表中添加了两个字段 fio_s 和 fio_r，这样就会有区别。

CREATE VIEW "problem_list_view" AS 
select problem_list.id,
        problem_list.date_start,
        users.fio_s as fio_sender,
        problem_list.problem_text,
        problem_list.solution_text,
        users.fio_r as fio_reciever,
        problem_list.date_end,
        statuses.name as status
from problem_list
left JOIN users on problem_list.sender_id = users.id
left join users on problem_list.receiever_id = users.id
left join statuses on problem_list.status_id = statuses.id

但我遇到了同样的错误。现在我不明白了。领域不同。告诉我哪里出了问题以及如何正确解决这个问题

sqlite3