hi,

i am updating existing table by using EmployeeID,here table having duplicate  records of EmployeeID.

main table:-

employeeid
------------
101
102
103

lookuptable:-

employeeid
------------

102
102
103
103
103
105
105

expected output
-----------------
employeedid      hc
-------------       -----
                   
102                   1
102                   0 or null (previously null before this load )
103                   1
103                   0 or null (previously null before this load )
103                   0 or null (previously null before this load )
105                   1
105                   0 or null (previously null before this load )
how to get First Matching records from lookup table and need to update according the target table by using EmployeeID as a Key?


thx