How To Sub Query in Crystal Report 10
Posted on 2006-05-31
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).