的PHP，PostgreSQL的，MySQL的 [英] php,postgresql,mysql

问题描述

我被困在查询中.我不知道这到底是不是问题..有1个可以帮助我吗?

I am stuck in a query.i don't know wats the problem exactly..can any 1 help me??

这是代码:

当我运行查询时，它引发错误:错误:关系"CONTRACTORS"不存在 第5行:来自承包商"

while i run the query it throws the error: ERROR: relation "CONTRACTORS" does not exist LINE 5: from "CONTRACTORS"

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

这篇关于的PHP，PostgreSQL的，MySQL的的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！