Hi Everyone
I have 3 tables- Employeeskills(Emp_ID,Skill_ID) Teams(Team_ID,Emp_ID,Skill_ID, Team_Name, Availability), JOBS(Job_ID, Team_ID, Date_Time, Location). now i need to group employees from the EmployeeSkills table to the Teams table, and then each Team must have all the skills like cleaning windows, dish-washing, flooring and bathroom cleaning. meaning i could have five employees under one team. but my problem is how do i group these EmployeeSkills under one team and so on?. because i need to assign each team to a job. im using SQLServer and ASP.net