FEH, strip that last column off of the insert columns, but still it errors.
Matthew P. Smith Web Developer, Object Oriented Naval Education & Training Professional Development & Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -----Original Message----- From: Smith, Matthew P -CONT(DYN) Sent: Thursday, January 09, 2003 3:41 PM To: SQL Subject: access insert select not working 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
