Subqueries possible?

Subqueries possible?

Greetings,

I am looking for the ability to use a subquery in the ZCQL. Is it possible and if so does anyone have some example code?

Failing that is there a way to join a table to itself?

Thank you,

      Catalyst Community