请各位帮忙看下SQL语句，5.0可以执行，4.0.26版本就不行了

CODE:

SELECT sum( je - htsk ) FROM (SELECT a.je, (SELECT sum( je ) FROM htje WHERE htbh = a.htbh AND deleted =0) AS htsk FROM htinfo a WHERE a.deleted =0 AND a.zt >=3 )t