Using Crystal Reports

[beggsr]

I am not sure if I am in the right forum, but any help would be appreciated.

I am using Crystal reports and connecting to a progress database.

I can run these 2 reports separately and they work, but when I combine the 2 queries with a union, I get a syntax error.


SELECT "Door"."Door_Name", "Person"."Last_Name", "Person"."First_name", "Person"."Card_num",
"Clearance"."Clearance_Name", "Person"."Disabled", "Person"."Deleted", "Person"."Expired", "Person"."Lost"
FROM ((((("PUB"."Group_Member" "Group_Member" INNER JOIN "PUB"."Groups" "Groups" ON
"Group_Member"."Group_ID"="Groups"."Group_ID") INNER JOIN "PUB"."Door" "Door" ON
"Group_Member"."Object_ID"="Door"."Door_ID") INNER JOIN "PUB"."Clear_Pair" "Clear_Pair" ON
"Groups"."Group_ID"="Clear_Pair"."Clear_Thru_Obj") INNER JOIN "PUB"."Clearance" "Clearance" ON
"Clear_Pair"."Clear_ID"="Clearance"."Clear_ID") INNER JOIN "PUB"."Clear_Person" "Clear_Person" ON
"Clearance"."Clear_ID"="Clear_Person"."Clear_ID") INNER JOIN "PUB"."Person" "Person" ON
"Clear_Person"."Person_ID"="Person"."Person_ID" WHERE "Person"."Disabled"=0 AND "Person"."Deleted"=0 AND
"Person"."Expired"=0 AND "Person"."Lost"=0 AND "Person"."Card_num">40000
ORDER BY "Door"."Door_Name"



union all





SELECT "Door"."Door_Name", "Clearance"."Clearance_Name", "Person"."Last_Name", "Person"."First_name",
"Person"."Card_num", "Person"."Disabled", "Person"."Deleted", "Person"."Expired", "Person"."Lost"
FROM {oj ((("PUB"."Door" "Door" INNER JOIN "PUB"."Clear_Pair" "Clear_Pair" ON
"Door"."Door_ID"="Clear_Pair"."Clear_Thru_Obj") LEFT OUTER JOIN "PUB"."Clearance" "Clearance" ON
"Clear_Pair"."Clear_ID"="Clearance"."Clear_ID") INNER JOIN "PUB"."Clear_Person" "Clear_Person" ON
"Clearance"."Clear_ID"="Clear_Person"."Clear_ID") LEFT OUTER JOIN "PUB"."Person" "Person" ON
"Clear_Person"."Person_ID"="Person"."Person_ID"}
WHERE "Person"."Disabled"=0 AND "Person"."Deleted"=0 AND "Person"."Expired"=0 AND "Person"."Lost"=0 AND
"Person"."Card_num">40000
ORDER BY "Door"."Door_Name"

 

[jdpjamesp]

What is the syntax error you get?

 

[RealHeavyDude]

You don't say anything about the version of the Progress/OpenEdge you're trying to connect to. If I remember correctly UNION was not supported in Progress V9. AFAIK, since 10.1A it should be supported.

Regards, RealHeavyDude.