DECLARE @edu_submark AS TABLE (Id INT IDENTITY(1,1),sm_mark INT,sub_lesson_id INT,st_id INT ,course_id INT)
INSERT INTO @edu_submark (sm_mark,sub_lesson_id,st_id,course_id) VALUES ( 97,1,9,3)
INSERT INTO @edu_submark (sm_mark,sub_lesson_id,st_id,course_id) VALUES ( 66,2,9,3)
INSERT INTO @edu_submark (sm_mark,sub_lesson_id,st_id,course_id) VALUES (22,2,1012,3)
INSERT INTO @edu_submark (sm_mark,sub_lesson_id,st_id,course_id) VALUES ( 32,1,1012,3)
INSERT INTO @edu_submark (sm_mark,sub_lesson_id,st_id,course_id) VALUES (15,1,13,3)
DECLARE @edu_sub_lesson AS TABLE (Id INT IDENTITY(1,1), sl_title NVARCHAR(30), lesson_id INT)
INSERT INTO @edu_sub_lesson(sl_title,lesson_id) VALUES ('Active Directory', 2)
INSERT INTO @edu_sub_lesson(sl_title,lesson_id) VALUES ('Win7', 2)
INSERT INTO @edu_sub_lesson(sl_title,lesson_id) VALUES ('UI', 1)
INSERT INTO @edu_sub_lesson(sl_title,lesson_id) VALUES ('Win SERVER 2008 R2 ', 2)
SELECT
a.sl_title, ISNULL(b.sm_mark,0) AS sm_mark
FROM
@edu_sub_lesson a
LEFT OUTER JOIN
@edu_submark b on a.Id = b.sub_lesson_id