topic OpenSQL Inline Select in Application Development and Automation Discussions

OpenSQL Inline Select

Khan — Wed, 18 May 2022 05:36:51 GMT

Hi Guys,

I have came across a problem for which we have a very simple solution in other SQL languages (like T-SQL, mySQL & pl/sql), but im having difficulty in OpenSQL.

Im trying to achieve an inline select, but getting an error; kindly guide

SELECT A~ebeln
A~BUKRS (Select T~BUTXT from T001 as t where T~BUKRS = A~BUKRS)

FROM EKKO as a

Re: OpenSQL Inline Select

Sandra_Rossi — Wed, 18 May 2022 06:31:56 GMT

OpenSQL is something which translates into many SQL languages, and so if one SQL doesn't support it, OpenSQL also won't support it.

Workaround: use a join.

PS: no need say "Inline SELECT" for any OpenSQL statement. It's just OpenSQL, not inline.