Update

[Anonymous]

Hi All,

I have two tables where the Reason code changes daily for the Delivery number.The Delivery number remains the same.I want update only few records(changed Reason Code) to be udpated from 2nd table to first table.For other records 1st table  which are dont have records in 2nd table should ( Reason Code)remain the same(undisturbed).

Outbound:

Load

DeliveryNumber,

Reason Code

From QVD;

New:

Load

DeliveryNumber,

Reason Code

From xls;

[sunny_talwar]

May be like this:

New:

LOAD DeliveryNumber,

    Reason Code

From xls;

Outbound:

LOAD DeliveryNumber,

    Reason Code

From QVD

Where Not Exists(DeliveryNumber);

Concatenate(Outbound)

LOAD *

Resident New;

DROP Table New;