Should the following syntax return all SkillNo from Skills even if SkillNo is not in SkillModuleLinks?
SELECT t1.SkillNo, t1.SkillLevel, t1.ModuleNo, t1.SortNo, t1.SMEditor, t1.SMEditDate, t1.SMEnterdate, t1.SMRecno, t2.CNSkill, t2.SkillName, t2.RPT, t2.KeyOrSpecialty, t2.SKEntered, t2.SKEdited, t2.SKEditor, t2.SkillStatus, t2.SkillComments, t2.SkillDefinitions, t2.ELHours FROM SkillModuleLinks t1 RIGHT OUTER JOIN Skills t2 ON t1.SkillNo = t2.SkillNo Values seem to be missing.

