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.

Reply via email to