Does Flexible Search support sub-query in FROM clause

[former_member1364266]

Hi folks, It is possible to join included query? I wrote simplified example, I think idea is clear. Any advice would be appreciate. Thanks.

 SELECT x.code, y.code
 FROM ({{ SELECT {p.code} FROM Product AS p}}) AS x
 LEFT JOIN ({{SELECT {p1.code} FROM Product AS p1}}) AS y
 ON x.code = y.code

[Former Member]

Yes for example:

 select count({code}),{C:id},{CV:version} from {Media as c}, {CatalogVersion as CV}, {Catalog as C} where {catalogversion}={CV:PK} AND {CV:catalog}={C:PK} AND ({C:id}='china' and {CV:version} like '%Test%') and {pk} IN ({{
 select {target} from {Product2MediaRelation}
 }})

[former_member1364266]

Thanks for your example.