topic Re: SQL : Select clause in Application Development and Automation Discussions

SQL : Select clause

Former Member — Wed, 18 Jan 2006 02:06:02 GMT

Hi all..

In open sql, is it impossible..?

Select a~*

into table gt_mara

from mara as a inner join marc as b

~~~

For performance, I want to fetch the fields of table mara. But, while compiling, occur error..

How to do..? What to do..? tell me plz..

Thank you!!

regards..

Re: SQL : Select clause

Former Member — Wed, 18 Jan 2006 02:42:19 GMT

Use this :

data : gt_mara like mara OCCURS 0.
Select *
into corresponding fields of table gt_mara
from mara as a inner join marc as b
ON a~matnr = b~matnr.

Ps: Reward points if helpful.

Re: SQL : Select clause

Former Member — Wed, 18 Jan 2006 03:47:40 GMT

Hi Kil,

Just an addition to the prev post..

Avoid the "into corresponding fields" for performance reasons... as long as the fields in the internal table are in the same order, use the below clause..

Select *

into table gt_mara

from mara as a inner join marc as b

ON a_{matnr = b}matnr.

Rgds,

Prash.