i need to update TblRemHp.tmp with Result of This Select

Select TblSub1.id from TblCategorias 
left join TblSubcategorias on TblSubcategorias.id_categoria = TblCategorias.id
left join TblSub1 on TblSub1.id_subcategoria = TblSubcategorias.id
left join TblRemHp on TblRemHp.id_categoria = TblCategorias.id and TblRemHp.id_subcategoria = TblSubcategorias.id
where TblRemHp.id_categoria = TblCategorias.id and TblRemHp.id_subcategoria = TblSubcategorias.id and TblRemHp.id_filtro1 = TblSub1.c1

i dont know how to make this.
Can somebody help me please?
Really thanks.