Julian, you've lost me here. With your setup, what is your select statement trying to do?
Originally posted by julian
SQL> select * from boss.abc
2 where 'X' = (select username from user_users)
3 union all
4 select * from boss.abc
5 where 'Y' = (select username from user_users);
To reduce confusion, wouldn't it be more readable to put the above like:
SQL> select * from boss.abc
2 where 'X' = USER
3 union all
4 select * from boss.abc
5 where 'Y' = USER;

But this is not my point. What I don't understand is how does your select differ from a simple (appart for confusing the original poster ):

SQL> select * from boss.abc;

And I don't think this is what hnetscape is looking for. In fact, I think a simple use of DECODE/CASE in a WHERE clause will cover his needs, but he would have to explain in more datail what he is trying to acchieve.