Dear all.
I using 2 databases with UNION ALL using "Add command" like this:
SELECT "t_customer"."s_name", "t_customer"."d_sys_created"
FROM "database1"."dbo"."t_customer" "t_customer"
UNION ALL
SELECT "t_customer"."s_name", "t_customer"."d_sys_created"
FROM "database2"."dbo"."t_customer" "t_customer"
database1 was active (valid) until 30.april.2016 and
database2 is active from 1.may.2016
database2 is copy from database1
now please open attach file here question:
thanks very much