You are welcome.

MartinJ

>ahhh!
>I knew I needed to ask the experts.
>that worked perfectly.
>
>Thanks a lot Martin.
>
>>

>>SELECT * FROM TB1, TB2
>>       WHERE TB1.ID=TB2.ID(+) AND TB1.type=TB2.type(+) AND
>>             TB1.type ='C'
>>

>>
>> MartinJ
>>
>>
>>>I need to do something like this:
>>>

>>>SELECT * FROM TB1 WHERE type ='C'
>>>and get the "Phone" from TB2 where type ='C'
>>>

>>>regardless if exist or not in TB2
>>>
>>>In other words,
>>>in the tables described below, John,George and Ringo have type 'C' in TB1 but George(ID 11) does not have a record type 'C' in TB2.
>>>I want him to show as phone =NULL because he does have Type 'C' in TB1
>>>
>>>What would be the correct syntax for this?
>>>

>>>TB1	
>>>ID--name---type
>>>-------------------
>>>45--John----C
>>>12--Paul----A
>>>11--George--C
>>>14--Ringo---C
>>>
>>>TB2
>>>ID--phone---type
>>>------------------
>>>45--5558888---C
>>>45--3337777---A
>>>14--5554545---C
>>>11--4541111---A
>>>