on 2015 Apr 24 12:52 PM
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
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Details of failed query >> https://answers.sap.com/questions/12764566/getting-no-types-registered-yet-with-sub-query-in.html
thanks!
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.