Question abot Select Statement

Former Member — Wed, 10 Dec 2008 16:03:16 GMT

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,

Re: Question abot Select Statement

tarangini_katta — Wed, 10 Dec 2008 16:05:47 GMT

Hi CD,

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

Thanks,