select * from TableB where UserName LIKE "Here I want to search other table column value"
is it possible ?