cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Does Flexible Search support sub-query in FROM clause

0 Kudos
3,001

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
View Entire Topic
Former Member
0 Kudos

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
0 Kudos

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

Former Member
0 Kudos

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

Former Member