This isn't how it works (or how BarneyB explained it). The statement is always INSERT INTO, followed by either VALUES or a SELECT statement. The select statement can have any result, as long as it has the same number of columns and the column datatypes match. So, your statement should probably look like this:
INSERT INTO tblProducts (ProdName, ProdDesc, ProdSRP, ProdPrice, ProdCost, SubcatID) SELECT name, description, srp, price, cost, subcategoryID FROM dolls_backup Pascal > -----Original Message----- > From: Donna French [mailto:[EMAIL PROTECTED] > Sent: 18 November 2004 23:13 > To: CF-Talk > Subject: Re: SQL Help Needed > > Okay, here's what I've come up with we'll see how it goes... > > SELECT lanesID, subcategoryID, name, availability, price, srp, cost, > description > FROM dolls_backup > INSERT INTO tblProducts(ProdName, ProdDesc, ProdSRP, ProdPrice, > ProdCost, SubcatID) > VALUES (dolls_backup.name, dolls_backup.description, dolls_backup.srp, > dolls_backup.cost, dolls_backup.subcategoryID) > > ~ Donna > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184846 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
