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 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.select date, ps.short_name, l.short_name, r.short_name from Schedule left join Presenters ps on (problem_set = ps.p_id) left join Presenters l on (literature = l.p_id) left join Presenters r on (research = r.p_id); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
