Issue with inner Join

Hi Team,

The INNER join between time_and_async and population_out is not giving the desired output. Its considering units which are not common on both table’s.

The below entered unit no is not common in both the table's. But its coming in the filter list when I did a direct join. However, if I convert the join into custom query then its giving me the desired result.

Did you guys come across this kind of scenario ever? Please help.

Please ask me if you are not clear with the question. Thanks!