Order by column count of another table

[skyline]

Hi,

Is it possible to order by a 2nd query count?
I am displaying one mysql table with a standard select query, but I need to order the results by the number of votes each listing has (which is from a 2nd table "votes")
Is this possibe?

Thanks

[guido2004]

Yes, join the two tables, group by the first table's id, and order by COUNT(*)

[skyline]

Thanks. Can I grab an example?

[skyline]

Scratch that, got it