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 NOT NULL}
problem_set, literature, and research reference a p_id in the presenter
list.
I am trying to create a view such that the output is the 4 columns in the
schedule table, except instead of the p_id being displayed, I want to
replace those values with the short_name.
For any given date, 2 of the 3 categories is set to a p_id and the 3rd is
null.
Any ideas?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
