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_member1364266]

I am trying to create a report, for this I need to write query with sub-query in from clause like it supports native SQL for example:

  SELECT
    p.ProductID,
    p.Name AS ProductName,
    p.ProductSubcategoryID AS SubcategoryID,
    ps.Name AS SubcategoryName
  FROM
    Production.Product p INNER JOIN
    (
      SELECT ProductSubcategoryID, Name
      FROM Production.ProductSubcategory
      WHERE Name LIKE '%bikes%'
    ) AS ps
    ON p.ProductSubcategoryID = ps.ProductSubcategoryID;

Does Flexible Search support sub-query in FROM clause?