Topic: How to use 'UNION' between two different databases Posted: 12 Jan 2015 at 9:07pm
Hello,
Could someone help me out. I am trying to find out if and how to use 'UNION' between two different databaseservers.
We have 2 different queries, each queries on a different database; one MySQL the other MSSQL.
Could someone tell me how to use 'UNION' between these 2 queries?
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 14 Jan 2015 at 4:15am
I have created a query in Excel that will access two databases, thus it stands to reason you can do it with a stored procedure, but I do not think Crystal will let you.
Joined: 29 Dec 2014
Location: United Arab Emirates
Online Status: Offline
Posts: 26
Posted: 27 Jan 2015 at 1:45am
AM not sure whether this is possible or not. But try to use 2 separate sql commands to use values from 2 different database by different data connections and if there is a link, link it at crystal level. Since its a union, I don't think that its required.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum