Sub-query in SQLQuery

In documentation ( http://www.gigaspaces.com/wiki/displa... ) there is written that SQLQuery supports "Sub-query - only for IN operations" but is not said how to use this feature. Could somebody post example of sub-query usage in SQLQuery ?

Regards
Lukasz

{quote}This thread was imported from the previous forum.
For your reference, the original is [available here|http://forum.openspaces.org/thread.jspa?threadID=3503]{quote}

You will have to break this into 2 separate queries. The result of the first one should be used with the second one.
You can use GigaSpaces Dynamic Query support to simplify the query construction:
http://www.gigaspaces.com/wiki/displa...