Home Select statement giving an aditionnal Null row
 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