Question abot Select Statement

[Former Member]

Hi,

Internal Table: IT1 (Fields -> FB)

I have populated IT1, it is sorted and does not contain any duplicate values for FB.

Internal Table: IT2 (Fields -> FA and FB)

DB table: TAB1 (Fields -> FA and FB) where FA is the unique key of the tabel.

I have a select statement:

SELECT fa fb FROM tab1 
INTO it2 
FOR ALL ENTRIES IN it1 
WHERE fb = it1-fb.

Since FB is not the unique key of the TAB1 there may be multiple entries for it in TAB1.

Will the above statement populate IT2 with these multiple entries or it will ignore the entries where FB repeats.

Thanks,

cd

[tarangini_katta]

Hi CD,

The select statement will enter all the multiple enries which is having with It1.

Thanks,