select 1 from ( select username as username from tbl1 union all select username from tbl2 union all select username from tbl3) awhere username = 'someuser'

select 1 from ( select username as username from tbl1 union all select username from tbl2 union all select username from tbl3) awhere username = 'someuser'