https://www.webmaster-forums.net/crss/node/1025150 en https://www.webmaster-forums.net/web-database-development/create-duplicate-record-based-existing-one#comment-1154214 <p>aside from bjmcg's sugestion, you could pull all the information from all the tables that correspond to the information fo the selection, then puts it into variables.</p> <p>you then insert all the new information into new sets.</p> Wed, 30 Jun 2004 20:14:48 +0000 m3rajk comment 1154214 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/create-duplicate-record-based-existing-one#comment-1154110 <p>You could have something like the following:</p> <p>INSERT INTO tablename (field1,field2,field3, etc) VALUES<br /> ((SELECT field1value FROM anothertable WHERE criteria = something),(SELECT field2value FROM yetanothertable WHERE criteria = something),etc,etc)</p> <p>Just an idea<br /> Bj</p> Tue, 29 Jun 2004 06:06:49 +0000 comment 1154110 at https://www.webmaster-forums.net