1,105,242 Community Members

Columns problem

Member Avatar
HunainHafeez
Posting Whiz
340 posts since Aug 2012
Reputation Points: 9 [?]
Q&As Helped to Solve: 4 [?]
Skill Endorsements: 2 [?]
 
0
 

i have tblScrutiny ,

COLUMNS:

teamid
name
userid

now confusion is that every team has many members, so how how would i mention them, like e.g i mention 1 member in teamid =1 , then in next row the teamid changes (identity=ON) , so how to mention 2nd member ?

Member Avatar
Ancient Dragon
Achieved Level 70
27,573 posts since Aug 2005
Reputation Points: 5,231 [?]
Q&As Helped to Solve: 3,028 [?]
Skill Endorsements: 115 [?]
Team Colleague
Featured
Sponsor
 
2
 

do you mean you want to list all members so that they are ordered by teamid? Or do you just want to select rows which have temaid = 2?

Do you know SQL? If not, then you need an SQL tutorial

Member Avatar
HunainHafeez
Posting Whiz
340 posts since Aug 2012
Reputation Points: 9 [?]
Q&As Helped to Solve: 4 [?]
Skill Endorsements: 2 [?]
 
0
 

its done, i am using another table "members"
Done !

Question Answered as of 1 Year Ago by Ancient Dragon
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: