multiple query with sqlite 2nd query gives only first result

multiple query with sqlite 2nd query gives only first result

select quantity, materialTypeId , (select typeName from invTypes where
TypeID in (select materialTypeId from invTypeMaterials where typeId=
12743))as material from invTypeMaterials where TypeID=12743
so this query gives me nice results except the column material. only shows
me the first entry instead of giving the name of each row. if i run these
sql seperate they work and i do see what i want. i just need them combined
into 2 columns.
what i want to do is, i query one table for data, one of the column has a
value wich i want to convert to a name, and that is in another table and
its linked by a unique TypeID
Chilly