Hi, ALL, sqlite> CREATE TABLE leagueplayers(id integer, playerid integer, value integer, currvalue double, foreign key(id) references leagues(id), foreign key(playerid) references players(playerid)); sqlite> INSERT INTO leagueplayers VALUES(1,(SELECT playerid,value,currvalue FROM players)); Error: table leagueplayers has 4 columns but 2 values were supplied
AFAICT, I am trying to insert 4 values in the table. Does anybody have an idea what is wrong? Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
