Query that sum balance of different event

Hi,
I need a help on Elasticsearch query solution for an sql query

select t1.*
from
(select * from abc where event=2003) as t1
inner join
(select * from abc where event =4012) as t2 on t1.c_id=t2.c_id
where t1.balance+t2.balance=0

Is this type of query in elastic search achievable

Can you rephrase your requirement in non sql way?

I have rephrased the query and I have posted till which point I got success and where it's breaking in below link

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.