0 Replies Latest reply: Sep 10, 2011 8:51 AM by Henco van Ee RSS

Load data from two different datasources in LINK table

Henco van Ee

Hi there,

 

I'm wondering if you guys know a solution for my problem.

The thing is that I am loading data from two different sources.

Both of them have a CUSTOMER table, which I would like to use in my QV doc.

There is a key between those two tables (databasetable1.customerid = databasetable2.customerid), so this far no problem.

 

In database 1 I have SALES. In the SALES table is a key to the CUSTOMER table.

In database 2 I have CONTACTS. In the CONTACTS is a key to the CUSTOMER table in database 1.

See the attached file for the structure.

 

The problem is that I would like to use a LINK table, but with this structure I think it is impossible. Is that right?

 

Kind regards,

 

Henco

 

 

EDIT:

 

The reason why I use a LINK table is because of the other data I am loading. Such as dates (mastercalendar) and other fields which are the same in different tables.