How To Sub Query in Crystal Report 10

Hi

I have this problem. I don't know Crystal Report very well but i need to make a query like this:

select * from People
where id in (select idpeople from Agency where cap=61100)

How can i translate this kind of query to sql ?
The "in" clause seems doesn't work with crystal report (it meens array).  

Thanks.