Regarding Join and Keep

[#1]

Hello,

Can we use a Join and keep together. For Eg

Left Join(ABC)

Left Keep(PQR)

Load

     *

from XYZ.qvd(qvd);

Regards

Sumeet

[michael_maeuser]

as far as is know no.

simply do first the left kepp, then load this table resident and left join it and drop the keep table

[michael_maeuser · Accepted solution]

alternatively do a where exists then you can join it at the same time

[#4]

Thanks a lottt Michael. Its working fine.

Regards

Sumeet