[sqlite] View with values in 1st table replaced by values in second table

Hi everyone. I am new to this mailing list, so hopefully I will be able to present my idea clearly to you: I have two tables designed as: Schedule { date TEXT UNIQUE NOT NULL problem_set INTEGER literature INTEGER research INTEGER} Presenters { p_id INTEGER PRIMARY KEY short_name TEXT UNIQUE NO

Re: [sqlite] View with values in 1st table replaced by values in second table

On 1/13/2011 2:44 PM, Josh Marell wrote: > I have two tables designed as: > > Schedule { > date TEXT UNIQUE NOT NULL > problem_set INTEGER > literature INTEGER > research INTEGER} > > Presenters { > p_id INTEGER PRIMARY KEY > short_name TEXT UNIQUE NOT NULL} > > problem_set, literature, and researc

Re: [sqlite] View with values in 1st table replaced by values in second table

On Thu, Jan 13, 2011 at 01:44:12PM -0600, Josh Marell scratched on the wall: > Schedule { > date TEXT UNIQUE NOT NULL > problem_set INTEGER > literature INTEGER > research INTEGER} > > Presenters { > p_id INTEGER PRIMARY KEY > short_name TEXT UNIQUE NOT NULL} > I am trying to create a view such

Re: [sqlite] View with values in 1st table replaced by values in second table

Thank you both for the advice, I had never thought to join on the same table using 3 different names like that, will have to keep that in mind! On Thu, Jan 13, 2011 at 9:27 PM, Jay A. Kreibich wrote: > On Thu, Jan 13, 2011 at 01:44:12PM -0600, Josh Marell scratched on the > wall: > > > Schedule