I am trying to join the two tables based on common bins from two sets, not able to perform it, neither I am not able to write a single query to combine two separate query from sets.
Joins are not directly supported. Instead, use get() or query() to read records from set 1. Then, use the resulting record list to read corresponding records from set 2 in one batch call.