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
>