iam having two tables ...
( Eg : sample ) one table have 1 (loannumber ) record other table have 3 (distinct loan number ) records .
i need to insert matched record need to update not matched need to insert how to do iam attaching sample table structure.
Like that matched records need to update with out matched need to insert
/* This table i need 3 records as like this
Lnno ExeType Status LstUpdt
H1CDGRN0300164 F N Null
BDCLMTF1403310001 P N NULL
NRCDKSH0200004 P N NULL