Joins In Sql Server 2012-->select Two Employee Names from a single table with two different employee Ids in a single stored procedure

Question

0.00/5 (No votes)

See more:

hai friends,
I tried one day about the below query but i didn't get the out put..

Query is:

SQL

select distinct L.LeadBudget,L.CompanyName,L.LeadTitle,L.Status,

E.Name as OwnerName,E.Name as 

CreatedUser

 from Leads L,Employee E where L.LeadId='2' 

 and E.EmployeeId=L.LeadOwner and E.EmployeeId=L.CreatedUserId

In The above query i want to get E.Name as OwnerName and E.Name as CreatedUser

from a single Employee tables)..where E.EmployeeId=L.LeadOwner and

E.EmployeeId=L.CreatedUserId

if i execute with out OwnerName or Created User i am getting the data..but i want to get both the names..

Please help me in this regard..

Thanks in advance

Posted 8-Feb-13 1:24am

.net333

Updated 8-Feb-13 17:49pm

v3

Add a Solution

3 solutions

Solution 1

Try this

SQL

select distinct L.LeadBudget,L.CompanyName,L.LeadTitle,L.Status,

E.Name as OwnerName,E.Name as

CreatedUser

 from Leads L join Employee E ON E.EmployeeId=L.LeadOwner and E.EmployeeId=L.CreatedUserId where L.LeadId='2'

Posted 8-Feb-13 1:42am

gagan sawaliya

Comments

.net333 8-Feb-13 7:44am

Thank you gagan..but it's not worked for me

gagan sawaliya 13-Feb-13 4:40am

Your question was not according to your answer. Plz correct your question

Solution 3

SQL

select distinct L.LeadBudget,L.CompanyName,L.LeadTitle,L.Status,

E.[Name] as [OwnerName],E.[Name] as

[CreatedUser]

 from Leads L join Employee E ON E.EmployeeId=L.LeadOwner and E.EmployeeId=L.CreatedUserId where L.LeadId='2'

Posted 8-Feb-13 1:55am

gagan sawaliya

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)

.net333 · Accepted Answer · 2013-02-08T01:58:00

finally i got the output...

SQL

SELECT l.LeadBudget, l.CompanyName, l.LeadTitle, l.Status, leadEmp.Name As OwnerName, createdEmp.Name As CreatedUser
FROM Leads l
     INNER JOIN Employee leadEmp ON(l.LeadOwner = leadEmp.EmployeeId)
     INNER JOIN Employee createdEmp ON(l.CreatedUserId= createdEmp.EmployeeId)
WHERE l.LeadId='2'