select t1.a , t1.b b1 , t1.c c1
, t2.b B2 , t2.c C2
from (
select * from tb where b='D'
) t1
left join (
select * from tb where b='C'
) t2 on t1.a=t2.a