Fix another problem with subroutine reuse in the RIGHT JOIN no-match code

Fix another problem with subroutine reuse in the RIGHT JOIN no-match code
for the subquery on the right-hand side of an IN operator.  The current code
works for all known cases, but seems unnecessarily complex and in need of
simplification.

FossilOrigin-Name: ad32da8045e691372871a05ca49688032e9c2bab769a07da6b6cfd6186d25955