topic Re: Select into another select statement in Application Development and Automation Discussions

Select into another select statement

Former Member — Thu, 24 Oct 2013 13:44:44 GMT

Hi all.

Can i write a statement like this

select matnr "the number of the material

(select maktx from makt where mantr eq mantr) "the name of the material

from mara

It is a example, but explain what i am looking for; write a select into another select statement

It is posible?

Thanks in advance.

Former Member — Thu, 24 Oct 2013 13:53:17 GMT

Hi Luiz,

Yes you can write such a statement(select inside another select statement).

However, this is not recomended.

Thanks
Sabal

Former Member — Thu, 24 Oct 2013 14:03:51 GMT

Hi,

Better use a join between those two tables.

Regards

Miguel

Former Member — Fri, 25 Oct 2013 14:18:49 GMT

Hi all

Thansk a lot for the help.

Following your opinion I could correct my mistake