Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chricholson
Starting Member
6 Posts |
 Posted - 2010-05-22 : 13:08:55
|
| I want my users table to be able to add friends. Problem is, this relationship presumably relates back to the same table? For example, user_id 3 would be friends with user_id 8, but that user_id exists in the same table. If I add another table "relationships" then I could state that a specific user is friends with a number, but this would not relate directly back to the users table.Anyone know of a tutorial or how to fix the problem?Many thanks,Chris |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-05-23 : 12:01:37
|
| Yes in that case it would be better having them in same table with userid and Parent(or FriendUserId)so you can go deep level to find the informations you need.Also all the contact informations and others will be better off by storing them in separate table. |
 |
|
|
|
|
|
Friends Feature