select item from database in table 1 where id matches up with other table code example

Example: select all if id in another table

SELECT * FROM terms WHERE id IN 
   (SELECT term_id FROM terms_relation WHERE taxonomy = "categ")