Crystal Reports Command reference

Message

   Hello, 

I have a question about select with SQL.
I have the following problem. I want to make 3 commands named: dd1, dd2, dd3.

dd1:

select f1,f2,f3,f4,f5 from table1

dd2:

select a1,a2,a3,a4 from table2
where a1=f1.table1

dd3:

select a1,a2,a3,a4 from table2
where a1=f2.table1

dd1 is the main select statement and I need to select twice from the same table but with different conditions. Can this be done? Can I reference a field from dd1 command in dd2 and dd3?

Thanks.

Edited by dragos78 - 03 Jul 2007 at 6:38am