sql - How to solve The multi-part identifier "r.StandardRate" could not be bound -


i getting following error query shown below:

msg 4104, level 16, state 1, line 37
multi-part identifier "r.resourceid" not bound.

msg 4104, level 16, state 1, line 16
multi-part identifier "r.standardrate" not bound.

can please me figure out?

query:

select                    vnd.name vendorname,      cct.name costcentrename,      ct.name costtype,     case when cct.isactive = 1 'active' else 'closed' end ccstatus,      isnull(cct.t1code,'') t1code,     cct.t2code,       '' [month],      convert(varchar, year(pf.period)) + '-' + convert(varchar, month(pf.period)) period,     pp.parentproformano,     pf.proformano,       vac.trafiguraaccountcode,     vac.pumaaccountcode,     pli.finalamt ammount,      ts.quantity quantity,     r.standardrate standardrate,     cmp.[text] proformastatus,     '' billableuom,      '' currency,     bet.entity ccbilledentity,     bcet.name ccbilledcompany,     pbet.entity proformabilledentity,      pbcet.name proformabilledcompany      proformaparent pp join      proforma pf on pf.proformaparentid = pp.id join      proformacostcentre pcc on pcc.proformaid = pf.proformaid join      costcentre cct on cct.id = pcc.costcentreid join      proformalineitems pli on pli.proformaid = pcc.proformaid                            , pli.proformacostcentreid = pcc.proformacostcentreid join      vendor vnd on vnd.id = pf.vendorid join      costtype ct on ct.id = pli.costtypeid join      vendoraccountcode vac on vac.vendormid = vnd.id                            , vac.costtypemid = ct.id join      codemaster cmp on cmp.id = pf.statusid join      billedentity bet on bet.id = cct.billedentitymid join      entity bcet on bcet.id = cct.billedcompanyentityid join      billedentity pbet on pbet.id = pf.billedentityid join      entity pbcet on pbcet.id = pf.billedcompanyid join      timesheet ts on ts.resourceid = r.resourceid 

there no object in query named r.


Comments

Popular posts from this blog

Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12:test (default-test) on project.Error occurred in starting fork -

windows - Debug iNetMgr.exe unhandle exception System.Management.Automation.CmdletInvocationException -

configurationsection - activeMq-5.13.3 setup configurations for wildfly 10.0.0 -