MySQL Query : SELECT s.idcolleges,s.address,s.colleges_name,s.zip,s.statusID,s.image_dir,s.images,s.college_type_chinese,s.asian,s.white,s.black_pct,s.hispanic ,city.StatusID,city.City,city.simplified as cityname,city.idcounty,co.county,co.simplified AS county_cn ,st.idstate,st.state,st.fullstate,st.simplified AS state_cn FROM colleges AS s LEFT JOIN `status` AS city ON s.statusID = city.statusID LEFT JOIN county AS co ON city.idcounty = co.idcounty LEFT JOIN state AS st ON co.idstate = st.idstate WHERE 1 = 1 AND st.idstate = 7 order by race_asian_pct asc limit 0,20
MySQL Error : Unknown column 'race_asian_pct' in 'order clause'
MySQL Errno : 1054
Message : Unknown column 'race_asian_pct' in 'order clause'
Need Help?