So here is my T-SQL statement :
NEWID() as Id,
ss.Id as SkillId,
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