Product: Sqlite 3
I am very, very new to SQL. At this time, I do not know how to ask the question properly.
I have two tables, tableA and tableB.
TableA has the following relevant columns:
| itemID | itemName |
| typeID |
If you have common values in
typeID then probably You can join on them like
select t1.itemName from table1 t1 join table2 t2 on t1.itemID = t2.typeID;