CEATE VIEW v_view AS select delegate_userid, orgid, login from table1 union select delegate_userid, orgid, login from table2 union select delegate_userid, orgid, login from table3 then do select * from v_view where login = 'SOME_USER' -- //www.freelists.org/webpage/oracle-l