Home Select statement giving an aditionnal Null row
Reply: 0

Select statement giving an aditionnal Null row

user797
1#
user797 Published in June 19, 2018, 6:19 pm

So here is my T-SQL statement :

SELECT 
	NEWID() as Id,
	ss.Id as SkillId,
	ss.Name,
	sc.Vote,
	sc.CandidateId,
	sc.Id As ScoreId

FROM dbo.SoftSkills ss 
LEFT JOIN dbo.Scorecards sc ON ss.Id = sc.SkillId 

Giving me this

But I also would like my select to return an additional row per SkillId where the CandidateId being Null.

Is that possible ?

Thanks for help.

EDIT : Can't write "Hello guys" at beginning of my post so saying hi there :D

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.328866 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO