Inner Join and Concatenate

[#1]

Data is currently being pulled from two locations. For instance, there is an Items table USA and Europe and Orders table USA and Europe.

In order to create one items table and one orders table I must perform concatenations to combine data from both databases.

Afterward I want to perform and inner join on tables Items and Orders, but am not able to due to concatenations.

ItemTable:

Load

ItemID,

'USA' As Loc;

SQL Select *

From Items;

Concatenate(ItemTable)

Load

ItemID,

'EU' As Loc;

SQL Select *

From Items;

Inner Join (ItemTable)

OrderTable:

Load

OrderID,

ItemID;

SQL Select *

From Orders;

Concatenate(OrderTable)

Load

OrderID,

ItemID;

SQL Select *

From Orders;

This code does not seem to work though. Any suggestions would be greatly appreciated.

[spsrk_84]

Hi,

1) Convert the Orders Table and Items into Qvd's and then do the inner join but before that drop the actual raw database tables.

2) Else while fetching the data from database tables itself do the union operation on tables

LIke

Load

ItemID,

LOC;

Select ItemID,Loc from Items

union

Select ItemID,Loc from Items

Try the above two steps hope ur problem will be resolved.

[#3]

Thank you... I will try the qvd approach and let you know my results.

[#4]

Just wanted everyone to know this worked... Thank you to everyone for their help.

[#5]

Just wanted everyone to know that the QVD approach worked wonders. Thank you everyone.