How to pass multiple values to a parameter?

[ekta22]

Hi,

I have created a lookup table that looks something like below:

a - a
a - aa
a - aaa
b - b
b - bb

I want to use this lookup table in my query. If a user selects a, the query should return values a, aa, aaa.

How can I use this lookup to get the above results. Thanks a lot in advance!

-E

 

[Gruuuu]

SELECT field2 WHERE field1 = 'a';

Unless I'm missing something really obvious?

 

[ekta22]

Thanks!