MySQL Query:SELECT area.areaid,area.areaname,company.userid,company.username,company.company,ur.school_name,ur.min_rank,ur.max_rank,ur.location FROM [pre]ranking ur LEFT JOIN [pre]company company ON company.username=ur.username LEFT JOIN [pre]area area ON area.areaid=company.areaid WHERE ur.source='QS' GROUP BY ur.username ORDER BY ur.min_rank <> 0 desc,ur.min_rank
MySQL Error:Unknown column 'ur.school_name' in 'field list' MySQL Errno:0
Message:MySQL Query Error
[ 点这里返回上一页 ]