Union of results from two different database connections

[Anonymous]

Hi,

Is it possible in SQleo to union the results of two queries which each look at different databases? e.g.:

SELECT COUNT(*) FROM DB1.PERSON

UNION

SELECT COUNT(*) FROM DB2.PERSON

Where DB1 and DB2 are two different connections set up in SQLeo (potentially to databases of different formats e.g. Oracle and Progress)?

Many Thanks
Sam

[PAscal]

Yes you can.
There are 2 ways to achieve that

1 launch the same query on distinct databases and save result in an unique csv file
as explained in
https://sourceforge.net/p/sqleo/discussion/tips/thread/384495ba/

2 use datacomparer feature, you will be able to display results side by side in a unique grid
left side
source : DB1
use connection: DB1
table: PERSON
column: empty
aggregates: count(*)

right side
all fileds empty except
target: DB2
use connection: DB2

you'get a grid with
DB1_count() | DB2_count()
12 | 24