MySQL Query : SELECT * FROM v9_picture AS a LEFT JOIN v9_picture_data AS b ON a.id = b.id WHERE a.catid IN (select catid from v9_category where catid = 19) order by b.xzzq asc LIMIT 20 MySQL Error : Unknown column 'b.xzzq' in 'order clause' MySQL Errno : 1054 Message : Unknown column 'b.xzzq' in 'order clause' Need Help?