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 · Accepted solution]

Hi Vova,

This one works for me

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

[former_member1364266 · Accepted solution]

Thanks a lot I it works, I need to be more accurate with quotes in Hybris :)

[Former Member · Accepted solution]

I'm getting "no types registered yet" error for some reason using this method.. any ideas why?

[Former Member · Accepted solution]

Details of failed query >> https://answers.sap.com/questions/12764566/getting-no-types-registered-yet-with-sub-query-in.html

thanks!