SELECT scales.id, man.name as brand FROM man, scales WHERE scales.man = man.id ORDER BY 4 [nativecode=1054 ** Unknown column '4' in 'order clause'] DB Error: no such field