You may try this.

select Userid form A as z, B as x where z.userid<>x.userid

Hope it is helpful to you.