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
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
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
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
4 matches
Mail list logo