Oracle里面,mysql 不晓得行不。
select a.A A,a.B B1, a.C C1, b.B B2, b.C C2 from Mk a, MK b where a.B = 'D' and b.B = 'C' and a.c = b.c order by a.A;