Hi Leo, > insert into 'tblName' Values (NULL, 'five'); > create table 'tblRefMaxName' ('ref' integer, 'nn' text); > insert into 'tblRefMaxName' Values (select max(id) from tblName, > 'eins');
Apart from the responses already from other posters, you should use the correct quotes for entities (table and columns names use double quotes: ") versus literals (single quotes: '). So it should read: insert into "tblName" values (null, 'five'); create table "tblRefMaxName" ("ref" integer, "nn" text); insert into "tblRefMaxName" select max(id), 'eins' from tblName; Tom BareFeet -- Comparison of SQLite GUI applications: http://www.tandb.com.au/sqlite/compare/?ml _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users