I have two tables
A: field1, field2
B: field1, field2

field2 always has a value in table A.
table B may or may not have a record with a value of field1 matching
that of table A.

I want to get the value of field2. I want the value for the record with
the value of field1 to come from Table B if there is a record there for
that value of field1, otherwise I want the value to come from table A.

If that is confusing, here is an example:

Table A
field1 field2
101 39
102 75
103 94
104 66

Table B
field1 field2
102 81
104 67

I want the results to be for the query for records where field1 IN
(101,102) obtained to be

field1 field2
101 39
102 81

Any hints?

--
Shelly

On 07.08.2011 22:55, sheldonlg wrote:
select A.field1,nvl(B.field2,A.field2)
from tableA A,tableB B
where A.field1=B.field1(+)
and A.field1 in (101,102)

Best regards

Maxim