Melvin: I do not think you need () around the SELECT ProductName.......
strSQL = "INSERT INTO testpurchase(ProductName) VALUES Select ProductName from Products where Yes-No_Fld='No'" Hope that Helps Andy ----- Original Message ----- > Hello everybody, > > I got lost on my SQL > > strSQL = "INSERT INTO testpurchase(ProductName) VALUES ( Select ProductName from > Products where Yes-No_Fld='No' )" > > it generates syntax error in query expression for the query after the "VALUES".... > any idea where is my mistake... > > thanks a lot > > melvin --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
