"select A, B, C,
  (select D, E, F,
    (select G, H from AA where ID = Z) from BB where ID2 = X),
      I, J
        from CC;"