Hi
To copy data from one table to another is....
Sqlexec(lnHandle,"INSERT INTO detail SELECT * FROM detail2 WHERE reference=?m.ref order by reference")

but how to copy from detail2 if the detail2 table is far from remote backend server ?