Left join resident tables

[#1]

Hi

I have this two tables

Temp1

Load distinct Names,Numbers

resident Oldtable

NoConcatenate

Sales:

Load

IDs,Products,Names

Resident OldTable

How do i Left join my Temp1 table to Sales when i have a NoConcatenate? Where should my left join be?

[#2]

Hi - I have done as you said with a QVD this works.

But i have another question. I think the left join makes the performance MUCH slower than i thought. Is there any other way to get the temptables values into Sales?? (where it joins on the right values)

[its_anandrjs]

Hi Thomas,

Thanks but it depends on your data model according to that you have to use left join or right join. I believe if values are unique in the key and depends on the rows also.

Regards