Trouble getting a solr join query done

[Yusnel Rojas García]

I have 2 indexes

products {
   id,
   name,
   type_id
   ..
}

and

categories {
   id,
   name
   ..
}

and I want to get all categories that match a name and have products in it.
my best guess would be:
http://localhost:8983/solr/categories/select?q=clothes&fl=*,score&fq={!join
from=type_id to=id fromIndex=products}*:*

but always get an empty response. help please!

Is a better way of doing that without using another index?