Subject Re: Facing Problem with limitations of IN CLAUSE
Author Ali Gökçen
Typo..

join wt1 y on y.id=x.id

also, you can use SP instead of view.