select T1.a, T1.b, T2.c, T2.d, T3.f from (select a, b from A) T1, (select c, d from B) T2, (select f from C) T3