SELECT as loop?

Hello all:
I need to create a loop using a SELECT statement whereby the number of loops are contingent on the value of a particular field in a table, i.e. if the field value is equal to '2', process another SELECT statement which will retrieve all rows of information where this would be true. I cannot use WHILE or FOR as part of the looping. Can anyone help?

--

 -=[ Kenneth Chui ]=-          | " In a consumer society there are
ah259_at_torfree.net              |   inevitably two kinds of slaves: 
k_chui_at_hotmail.com             |   the prisoners of addiction and
ken.chui_at_tba.tlug.org          |   the prisoners of envy."