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 ?
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
its done, i am using another table "members"
Done !
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.