Hi! I don't know if I'm missing something. I did a simple join query asking for one column in each table. The result contains the same column from the right table. (I read about it in the streaming expressions).
curl --data-urlencode 'stmt=select t1.type AS type1, t2.type AS type2 from iocs t1 join iocs2 t2 on (t1.ip=t2.ip) limit 1' http://localhost:8983/solr/iocs/sql {"result-set":{"docs":[{"type2":"BOT_IP","type2":"BOT_IP"},{"EOF":true,"RESPONSE_TIME":555}]}} Thanks for your help, Jordi
