Hi,
You may use MERGE statemet for better performance. Here is sample script according to your example:
MERGE INTO Table2 AS TARGET
USING (
SELECT Name, date, amount, chequeno
FROM Table1
) AS SOURCE
ON TARGET.Name = SOURCE.Name
WHEN MATCHED
THEN UPDATE SET TARGET.date = SOURCE.date ,
TARGET.amount = SOURCE.amount ,
TARGET.chequeno = SOURCE.chequeno
WHEN NOT MATCHED BY TARGET THEN
INSERT (Name, date, amount, chequeno ) VALUES (SOURCE.Name, SOURCE.date, SOURCE.amount, SOURCE.chequeno)
;
Thanks,
Baliram Suryawanshi