I have a query



which works, however I don't want to order by the status.id

I want to order by types.description, however if I replace status.tid with that it doesn't order at all



If I replace it by name (because the query says to return the field as name) it says the field doesn't exist

Any ideas how to achieve what I want? I've attached a dump of the tables

<edit>Just realised that doesn't even work as intended

it appears that your table "status" is being shown as a command and not your table.

That could be an issue. What happens if you use 'status'

Thats not the problem, thats just because PHPMyAdmin's SQL highlighter isn't fantastic.

Anyway got it working, was over complicating things, didn't need a join