Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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