Join 2 tables for viewing

I got 2 tables of recipes, and recipe_ratings
and I don't know how to get the AVG(rating_value) from recipe_rating
and join them

Recipes table (get '*') and join it with AVG(recipe_value)
order by date_posted


Click here view more answers http://ift.tt/1QRSJi6