OpenSQL Inline Select

[Khan]

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

[Sandra_Rossi]

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.