Thanks for the reply Gregory,
if you have a time would like to give a sample via which is containing tables of fields myguid,mydtime . i need a prototype for situation 1 - 2 and 3

(1) in tableA and not in TableB
>>> insert into tableB

(2) in tableB and not in TableA
>>> insert into tableA

(3) exists in both tableA and tableB

TIA