rporter45
asked on
In Crystal Reports, then Database Expert, under Current Connection, then Add Command, then I drop SQL that works in
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.
Example:
SELECT DISTINCT x.GfCnBio_Import_ID
FROM
(
SELECT DISTINCT a.GfCnBio_Import_ID
FROM "Command" a
UNION ALL
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.
Please help.
screenshot.JPG
How do I properly reference these Commands in new Commands I am creating.
Example:
SELECT DISTINCT x.GfCnBio_Import_ID
FROM
(
SELECT DISTINCT a.GfCnBio_Import_ID
FROM "Command" a
UNION ALL
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.
Please help.
screenshot.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mlmcc