i want to select Dept_Name from Tbl_Dept with multiple Employees from Tbl Tbl_emp for relationship i'm using Dept_ID field

Question

0.00/5 (No votes)

See more:

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

Posted 25-Mar-14 22:51pm

amitavin_Sharma

Updated 29-Mar-14 10:38am

CHill60

v2

Add a Solution

Comments

Bala-Seequel 27-Mar-14 2:59am

Ithink almost not possible to get output as u want, instead can get only in normal form as

dept_id emp_nmae
1 Ram
2 Mohan
3 Sohan
2 Reeta
3 Sonu
1 Karan

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Gauri Chodanker · Answer 1 · 2014-03-29T10:35:00

Solution 1

SQL

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

Posted 29-Mar-14 10:35am

Gauri Chodanker

Comments

CHill60 29-Mar-14 16:53pm

If you had tested this you would realise that it produces
emp_id emp_name dept_name
1 Ram .NET
2 Mohan Java
3 Sohan Php

Which is not what the OP wanted

CHill60 · Answer 2 · 2014-03-29T10:55:00

Solution 2

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[^]

Posted 29-Mar-14 10:55am

CHill60

Updated 29-Mar-14 10:59am

v2