SELECT * FROM TB1 WHERE type ='C' and get the "Phone" from TB2 where type ='C'regardless if exist or not in TB2
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