Eng 6012 inexists sp

No, I don't but added.

The strange thing, it works despite the fact that subquery ends up having two TVEs as parameters. The only difference   is that these TVE are from different tables. The subquery with two parent TVEs from the same table fails.