Re: [sqlite] Select name if exists in the group/table

[Micro Mega Dust]

Hi pepone. onrez,

I create a separate table for each group, in order to avoid redundant
data in the table. Your solution is interesting, but I think that
allow redundancy in "GroupUsers". For example:

+-------+---------+
|userId | groupIp |
+-------+---------+
| foo   | groupA  | <--- !
| bar   | groupA  |
| quux  | groupC  |
| foo   | groupB  |
     (...)
| foo   | groupA  | <--- !
+-------+---------+




2006/11/18, pepone. onrez <[EMAIL PROTECTED]>:

Hi Micro

why you create a separate table for each group?

usaly the groups are all in a singel table

I think is a veter aproact one table for users other for groups and a
third table for the realtion betwen users and groups, you can view all
the groups that a user beyons to with a

select * FROM GroupUsers where userId='user'

Users
userId;
name;

Groups
groupId;
name;

GroupUsers
userId;
groupId;