Skip to Content
0
Former Member
Jan 30, 2009 at 02:25 AM

Optimizing Select statement

29 Views

Hi,

Any ideas on how to use 'select for all entries' (or equivalent) syntax to get single record even if i have multiple records in the db.

Scenario:

internal table has multiple entries and each entry in turn might have multiple records which are relevant. However, single hit/one db record would give me the required details.

Thanks,

Gopal

Internal table

-


Group1

Group2

ZMAPTABLE

-


Group1___area1___code1

Group1___area2___code1

Group2___area1___code2

Group3___area2___code2

Result after doing select

Group1__code1

Group2__code2