Question

oracle 数据库语句执行错误

select isnull(sum(round(isnull(ZJZHYEB_HQYE,0),2)+round(isnull(ZJZHYEB_TZJE,0),2)+round(isnull(ZJZHYEB_XDJE,0),2)),0) as JEHJ from lc0019999.ZJZHYEB where ZJZHYEB_ZHNM='0000000559' and ZJZHYEB_RQ>='20151121'

若以下回答无法解决问题，邀请你更新回答

Answer 1

报的什么错误？from lc0019999.ZJZHYEB 多了一个.点？你这个ZJZHYEB是别名？