On Thu, 10 Oct 2013 12:29:21 -0400 "jose isaias cabrera" <cabr...@wrc.xerox.com> wrote:
> > INSERT INTO SimplePrices > > SELECT cust || '1', class, slang, tlang, TransferCost, Price > > FROM SimplePrices WHERE cust = 'XEROX'; > > > > Kudos for the primary key declaration, btw. :-) > > Thanks for the kudos and the support. So, are you saying that this > is also true? > > INSERT INTO SimplePrices > SELECT 'XEROX1', class, slang, tlang, TransferCost, Price > FROM SimplePrices WHERE cust = 'XEROX'; Yes, that works too. All that matters is that the values produced by SELECT meet the requirements of the columns they're being INSERTed into. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users