Insert null rows where needed

Question

I am trying to preserve the structure of the results and replace the player id's with player firstnames. IE I want the nulls to stay where they are to preserve the ordering. see below:

Step 1) replace FK_WinnerID with FirstName and preserve the nulls.

enter image description here

Problem is sql statement is removing nulls

enter image description here

This is what it should look like:

enter image description here

Use a RIGHT join instead of a LEFT

Conrad Frix
– Conrad Frix

2013-12-05 23:34:08 +00:00
Commented Dec 5, 2013 at 23:34 — Conrad Frix
– Conrad Frix, Commented Dec 5, 2013 at 23:34

Conrad Frix · Accepted Answer · 2013-12-05 23:38:35Z

2

When you have

FROM A LEFT JOIN B

That means you want everything in A and matching records in B

But you want everything from B and matching records in A so you need to do either

FROM B LEFT JOIN A

OR

FROM A RIGHT JOIN B

answered Dec 5, 2013 at 23:38

Conrad Frix

52.8k13 gold badges99 silver badges158 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

cpeterson · Accepted Answer · 2013-12-05 23:37:38Z

0

SELECT FirstName
FROM Players right join TournamentPrizes
ON Players.PlayerID = TournamentPrizes.FK_WinnerID
WHERE FK_TournamentID=1043 
order by TournamentPrizes.Place ASC

answered Dec 5, 2013 at 23:37

cpeterson

631 silver badge9 bronze badges

Collectives™ on Stack Overflow

Insert null rows where needed

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related