> How do I copy the contents of a BLOB field in one table to a BLOB
> field in another table?
>

simple
UPDATE TABLE2 SET BLOB1=(SELECT BLOB1 FROM TABLE1 WHERE TABLE1.ID=N)
WHERE TABLE2.ID=Y;

Alan