I have a Crystal Report where I am creating my own SQL based on MS Access data as source. I have had success creating and running these SQL statements. Where I am running into problem is using already created SQL statements in Crystal that are all separate Commands (i.e. Command, Command_1, etc.). Each of these Commands that represent separate SQL statements is listed under Database Fields on right hand side of Crystal.
How do I properly reference these Commands in new Commands I am creating.
SELECT DISTINCT x.GfCnBio_Import_ID
SELECT DISTINCT a.GfCnBio_Import_ID
FROM "Command" a
SELECT DISTINCT b.GfCnBio_Import_ID
FROM "Command_1" b
) AS x;
I want to create a third Command (SQL) that makes use of Command and Command_1.