Skip to Content
0
Former Member
Feb 02, 2005 at 07:19 AM

For all entries

59 Views

Hi,

I belive I have some issue regarding "for all entries" ?

clear: i_mara,i_mara[].

  • i_mara now includes 0 row.

  • i_mvke now includes 1 row.

  • Get MARA

select *

from mara

into corresponding fields of table i_mara

for all entries in i_mvke

where matnr eq i_mvke-matnr.

i_mara now includes 10000 rows.

i_mvke now includes 1 row.

I'm confused.... a for all entries in should work as a INNER JOIN ...?

I want i_mara to include only 1 row after the select..

//Martin

Message was edited by: Martin Andersson