INSERT INTO tbOptions (tbQuestionsFK, Value, supplementalValue1, supplementalValue2) SELECT 20 AS tbQuestionsFK, tbContentClassifications.id, tbContentClassifications.name, tbContentClassifications.description FROM tbContentClassifications where tbContentClassifications.tablePK >= 5 AND tbContentClassifications.tablePK <=23
"syntax error in INSERT INTO statement" tried it, but I still had that extra column on there before, took it off and still errors. Have also tried a semicolon at the end of the statement. Thanks, though. -----Original Message----- From: Scott Weikert [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 3:56 PM To: SQL Subject: Re: access insert select not working Need 'INSERT INTO", not just "INSERT". :) At 03:40 PM 1/9/2003 -0600, you wrote: >I think this would fly in MS SQL server(which I usually use) but I'm getting >and error from access when I try to run it: > >INSERT tbOptions (tbQuestionsFK, Value, supplementalValue1, >supplementalValue2, supplementalValue3) >SELECT 20 AS tbQuestionsFK, tbContentClassifications.id, >tbContentClassifications.name, tbContentClassifications.description >FROM tbContentClassifications >where tbContentClassifications.tablePK >= 5 >AND tbContentClassifications.tablePK <=23 > > >It tells me "syntax error in INSERT INTO statement", even though it's a >insert select not a insert into. >Matthew P. Smith >Web Developer, Object Oriented >Naval Education & Training Professional >Development & Technology Center >(NETPDTC) >(850)452-1001 ext. 1245 >[EMAIL PROTECTED] > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
