Get selected and missing records in a view

Hi;

I need your help in order to solve a problem. I will try to explain it the simplest i can.

Let say i have a table T with 3 fields A, B, C.

I have to make a view on this table with a condition on A, something like : select * from T where A in (a1, a2, a3);

The problem is that the values given in the where conditions can not exist in the table. That is to say, that there are records with a1, a2 but for instance not with a2.

What I want is that my views gives me back the following result :

a1, b1, c1
a2, null, null
a3, b3, c3

or

a1, b1, c1
a3, b3, c3
a2, null, null

There is another condition on this work : i can only read the table T and i can not make changes on it.

So, is there an oracle genius to help me ?

Thanks a lot for your help.

Jerome Received on Mon Mar 03 2003 - 02:46:57 CST