CODEWITHSUNDEEP
mysql
Konrad
Konrad

Reputation: 158

MySQL Select Same Columns Twice

I have a table populated as

userID INT
firstName VARCHAR(255)
lastName VARCHAR(255)
refID INT

Where refID is the userID, this particular user was referred by.

I want to create a report that can pull the referrer and referee in one query, which I'm having trouble figuring out.

The final report would look like

referrer first name,referrer last name,referee first name,referee last name

Upvotes: 0

Views: 75

Answers (2)

Alex Monthy
Alex Monthy

Reputation: 1877

select rr.firstName, rr.lastname, re.firstname, re.lastname
from mytable rr left join mytable re
on rr.userId = re.refId

Upvotes: 0

Marc B
Marc B

Reputation: 360862

I'm guessing your above table links to a users table, or similar, so you'd want:

SELECT referrer.firstname, referrer.lastname, referee.firstname, referee.lastname
from yourtable
left join users AS referrer ON yourtable.userID = referrer.id
left join users AS referree ON yourtable.refID = referee.id

Upvotes: 1

Related Questions