Topic: Selecting data fields from 2 databases? Posted: 08 Mar 2016 at 9:43am
I have 2 databases (DB1 and DB2).
I would like to select Donor_Draw.Visit_ID from DB2
with a left outer join to DB1.Donor_Queue on DB1.Donor_Queue.visit_id = DB2.Donor_Draw.Visit_ID.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 08 Mar 2016 at 10:01am
Are you creating a command?
otherwise you can just use the UI to select 2 tables, make the join on the field and set the join to an outer join.
You have to use fields form both tables or also set the join to enforced.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 09 Mar 2016 at 3:16am
If the DB's are MS-SQL. Then if you use fully qualified names for the databases, then it should work (in theory). I have done it with one report some years ago (I had to google for an answer).
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
IP Logged
