Combining Tables for Sorting

[mcmuney]

I'm using this sql to pull a list of movies:

 

$mansql="SELECT * FROM sc_movies ORDER BY mov_year DESC";

 

What I'd like to do next is to ORDER them with highest rating, the rating is stored in a different table, this is what I've tried, but it doesn't work, what am I doing wrong:

 

$mansql="SELECT mov.*, avg.* FROM sc_movies mov LEFT JOIN sc_movies_rate_avg ON mov.mov_id=avg.scm_mem_id ORDER BY (avg.total_value/avg.total_votes) DESC";

[lightningstrike]

I believe you didn't specify sc_movies_rate_avg AS avg.