You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by s.PRICE asc ) a left join REI_DB_PROPERTY b on b.ID = a.NEIGHBORHOODID' at line 3 - Execute Query False! select a.*,b.NAME_EN as BEDROOMSIZE from (select a.*,b.NAME_EN as NEIGHBORHOODNAME from (select p.*
from REI_OP_PROPERTY p,REI_OP_STATISTICS s,users u
where s.PROPERTYID = p.PROPERTYID and u.username = s.AGENTID and s.RENATALORSALE = 's' and u.id = order by s.PRICE asc ) a left join REI_DB_PROPERTY b on b.ID = a.NEIGHBORHOODID) a left join REI_DB_PROPERTY b on b.ID = a.BEDROOMS