Re: Linking data together

[Peter Brawley]

Is this what you mean?

start transaction;
update tbl set mate='004' where serial='001';
update tbl set mate='001' where serial='004';
commit;