我想从Tbl_Dept中选择Dept_Name与来自Tbl Tbl_emp的多个Employees关系我正在使用Dept_ID字段 [英] i want to select Dept_Name from Tbl_Dept with multiple Employees from Tbl Tbl_emp for relationship i'm using Dept_ID field

问题描述

我正面临一个问题，我想要这样的结果请帮帮我

我能算出一个部门的员工人数，但我无法按照自己的意愿展示

提前致谢



Tbl_Dept

 Dept_ID Dept_Name 
 1 .NET 
 2 Java 
 3 Php 

Tbl_Emp

 Emp_ID Dept_ID Emp_Name 
 1 1 Ram 
 2 2 Mohan 
 3 3 Sohan 
 4 2 Reeta 
 5 3 Sonu 
 6 1 Karan 

结果

 Dept_Name员工
 .NET Ram，Karan 
 Java Mohan，Reeta 
 Php Sohan，Sonu 

解决方案

 选择 emp_id，emp_name，dept_name 
 来自 tbl_emp 
 内部  join  tbl_Dept   tbl_Dept.Dept_id = t bl_emp.emp_id 

要以逗号分隔格式获取列，请查看此链接 http://stackoverflow.com/questions/455423 /如何转换一个表的一个表到一个csv-string-in-sql-server-without-using [ ^ ]



和另一个

http://stackoverflow.com/questions/12435284/comma-separated-values-in-one-column-sql-server [ ^ ]

I’m facing a problem I want result like this please help me
I’m able to count the number of employees in a department but I can’t show as I want
Thanks in advance

Tbl_Dept

Dept_ID	Dept_Name
1	.NET
2	Java
3	Php

Tbl_Emp

Emp_ID	 Dept_ID	Emp_Name
1	 1	        Ram
2	 2	        Mohan
3	 3	        Sohan
4	 2	        Reeta
5	 3	        Sonu
6	 1	        Karan

Result

Dept_Name	Employees
.NET		Ram,Karan
Java		Mohan,Reeta
Php		Sohan,Sonu

解决方案

select emp_id, emp_name, dept_name
from tbl_emp
inner join tbl_Dept on tbl_Dept.Dept_id = tbl_emp.emp_id

To get a column in a comma-separated format have a look at this link http://stackoverflow.com/questions/455423/how-to-turn-one-column-of-a-table-into-a-csv-string-in-sql-server-without-using[^]

and another
http://stackoverflow.com/questions/12435284/comma-separated-values-in-one-column-sql-server[^]

这篇关于我想从Tbl_Dept中选择Dept_Name与来自Tbl Tbl_emp的多个Employees关系我正在使用Dept_ID字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！