sql - sqlite3 query return field from table1 based on information from table2 -

product: sqlite 3

i very, new sql. @ time, not know how ask question properly.

i have 2 tables, tablea , tableb.

tablea has following relevant columns:

| itemid | itemname | 

tableb has following relevant columns:

| typeid | 

i want query return itemname each typeid

based on limited knowledge , searching, i've started looking sql join type statements, i'm having difficulty figuring out.

any advice or direction appreciated.

if have common values in itemid , typeid can join on them like

select t1.itemname  table1 t1 join table2 t2 on t1.itemid = t2.typeid;