Well basically I have two tables with a field which is the same in both table (As in the fields are both set to an attachment). Now somehow I would like to extract all the field from one table to another. When I try the following syntax the following error message occurs.

INSERT INTO Student (Photo) SELECT Photo FROM Students_Record1;

ERROR MESSAGE : An Insert INTO query cannot contain multi-valued field.

From this error message I noticed that this got to do with the datatype as it was set to an attachment.

So I did the following code

INSERT INTO Student (Photo,Photo.FileData,Photo.FileName,Photo.FileType) SELECT Photo,Photo.FileData,Photo.FileName,Photo.FileType FROM Students_Record1;

Which also outputs the same error as the above.

ERROR MESSAGE : An Insert INTO query cannot contain multi-valued field.

Anyone knows how can I extract an attachment from one table to another using SQL ?

Thank you!