Union Tables within different database in crystal

[cazellnu]

I have tables with the same schema sitting in the database (all with Pervasive SQL). I wonder what would be the best approach to union these table within the report. The tables contains two columns. Customer number and the balance,but a customer may perhaps exists in different tables. I had been trying to use Crystal Dictionary and SQL Designer 8.5 and use crytal report 10 to develop report aginst these file and not been success so far. Any help and/or suggestion greatly apperciate... Thanks all

 

[synapsevampire]

First suggestion, don't use the Crystal SQL Designer.

You can use an Add Command object in Crystal 10, meaning you can paste in REAL SQL. So if you can write the SQL, it should work there. The first thing under your connection should be an Add Command.

-k

 

[cazellnu]

I did use the add command object but I cannot get the table sitting in the db1 talk to the table sitting in the db2. Please help.