On 5 Jul 2013, at 2:10am, Igor Korot <ikoro...@gmail.com> wrote: > CREATE TABLE players(playerid integer primary key, name char(50), age > integer, value integer, currvalue double...); > CREATE TABLE playersinleague(id integer, playerid integer, value integer, > currvalue double, draft boolean, isnew char(1),...); > CREATE TABLE playerpositioninleague(id integer, playerid integer, > positionid integer); > > The problem comes when I try to add a player to a league and later on > delete the new players in the league. > I also need to keep leagues independent, meaning that new players in one > league will not appear on the new league.
You don’t need three tables for this, just one. Have just the player table, but add two fields to it: league and positioninleague. I don’t understand the other fields in your playersinleague table, but I’m guessing they can be added to the player table too. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
