Skip to Content
0
May 25, 2016 at 09:16 AM

displayed data with use 2 databases

26 Views

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

Attachments

union_all.JPG (74.7 kB)