Joint tables query

[Rommeo]

my tables are like :

 

tablePost

id | content | categoryid

7 |hello woo| 5

8 |woot woo| 5

 

tableCategory

id| catname

5 | random

6 | favorites

 

I want to print all posts with the names of the categories they belong to,

 

example result :

random : 7 hello woo

random : 8 woot woo

 

 

I tried this :

select * from tablepost where categoryid = ( select id from tablecategory ) order by id desc;

 

I m sure this is all wrong since it did not work, I m not good at queries, can someone help me to figure this out ?

[joel24]

there are a few different ways you can join tables, my favourite is

SELECT tp.id, tp.content, tc.catname
FROM tablePost tp
JOIN tableCategory tc ON tp.categoryid = tc.id

 

have a read up here or on google.