We are trying to convert some SQL queries to Discovery query language.
The SQL queries contain inner joins on some fields. So is it possible to have a inner join or are there alternatives for the same.
There is no join. As to alternatives, it really depends upon what you are trying to achieve.
Retrieving data ...