Select with two tables in MySQL -

this question has answer here:

• sql select multiple tables 6 answers

i have 2 tables hits , posts. in hitstable have id_post,hits , poststable have id,title

i need build report posts related hits , order hits. can me select ?

thanks

select   posts.id id, posts.title title, hits.hits hitsdate     posts inner join hits on hits.id_post = posts.id order hits.hits