分组表属性 [英] Grouping table attributes

问题描述

大家好

我有3个表-Employeeskills(Emp_ID，Skill_ID)团队(Team_ID，Emp_ID，Skill_ID，Team_Name，Available)，JOBS(Job_ID，Team_ID，Date_Time，位置).现在，我需要从EmployeeSkills表到Teams表对员工进行分组，然后每个团队必须具备清洁窗户，洗碗，地板和浴室清洁等所有技能.这意味着我可以在一个团队中拥有五名员工.但是我的问题是如何将这些EmployeeSkills归为一个团队，依此类推?因为我需要分配每个团队一份工作.我正在使用SQLServer和ASP.net

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

推荐答案

能否请您简要说明一下我的意思是在此处生成您需要的输出?

Can u please brief your question i mean produce output u need here?

这篇关于分组表属性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！