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