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
>>