我被困在一个查询中。我不知道到底是什么问题。任何人都可以帮助我吗?
这是代码:
当我运行查询时,它抛出错误:错误:关系“CONTRACTORS”不存在
第 5 行:来自“承包商”
select cont.name, cont.total,cp.contractor_id,cp.amount_paid,wt.id
FROM
(
select name,sum(amount_to_be_paid) as total
from "CONTRACTORS"
group by name
) cont
left join
(
select contractor_id,sum(amount_paid) as amount_paid
from "CONTRACTOR_PAYMENTS"
group by contractor_id
) cp
on cont.id= cp.contractor_id
left join worktypeids as wt on cont.worktypeid_id = wt.id AND wt.project_id=2
尝试这个
select cont.name, cont.total,cp.contractor_id,cp.amount_paid,wt.id
FROM
(
select name,id, sum(amount_to_be_paid) as total
from contractors group by name,id
) cont
left join
(
select contractor_id,sum(amount_paid) as amount_paid
from contractor_payments
group by contractor_id
) cp
on cont.id = cp.contractor_id
left join worktypeids as wt on cont.worktypeid_id = wt.id AND wt.project_id=2
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)