Optimizing Select statement

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