Re: SQL Question

2002-08-17 Thread Oded Arbel
Shlomi Fish wrote: On Fri, 16 Aug 2002, Oded Arbel wrote: Shlomi Fish wrote: I have three tables: clubs, users and permissions. clubs contains a Club_ID (an integer). users contains a User_ID. Permissions contains both as well as a Subject

Re: SQL Question

2002-08-17 Thread Shlomi Fish
On Fri, 16 Aug 2002, Oded Arbel wrote: > Shlomi Fish wrote: > > >I have three tables: clubs, users and permissions. clubs contains a > >Club_ID (an integer). users contains a User_ID. Permissions contains both > >as well as a Subjects field (a boolean). > > > >Now, a user is allowed to edit the d

Re: SQL Question

2002-08-16 Thread Oded Arbel
Shlomi Fish wrote: >I have three tables: clubs, users and permissions. clubs contains a >Club_ID (an integer). users contains a User_ID. Permissions contains both >as well as a Subjects field (a boolean). > >Now, a user is allowed to edit the data associated with a club if he has a >record in the

Re: SQL Question

2002-08-16 Thread Sagi Bashari
From: "Shlomi Fish" <[EMAIL PROTECTED]> > > I have three tables: clubs, users and permissions. clubs contains a > Club_ID (an integer). users contains a User_ID. Permissions contains both > as well as a Subjects field (a boolean). > > Now, a user is allowed to edit the data associated with a club

SQL Question

2002-08-16 Thread Shlomi Fish
I have three tables: clubs, users and permissions. clubs contains a Club_ID (an integer). users contains a User_ID. Permissions contains both as well as a Subjects field (a boolean). Now, a user is allowed to edit the data associated with a club if he has a record in the permissions table (with