ÃâÆÇÀ» À§ÇÑ µðÁöÅÐ ÆíÁýµðÀÚÀÎ ÀεðÀÚÀÎ ½Ç¹«

ÆнºÆ®Ä·ÆÛ½ººÐÁ¡ ¿ø°ÝÆò»ý±³À°¿ø

• ±³¾È´Ù¿î
• °­»ç¼Ò°³
• ÇнÀ°¡À̵å

SELECT (SELECT cate1_name FROM L005 WHERE cate1_code = a.cate1_code) , lec_period_month , lec_capacity , price_normal , lec_subject , content1 , content2 , content4 , (select ti_name from m003 where a.teacher_id = ti_id) , (select subject1 from m003 where a.teacher_id = ti_id) , (select subject2 from m003 where a.teacher_id = ti_id) , (select content5 from m003 where a.teacher_id = ti_id) , (select content6 from m003 where a.teacher_id = ti_id) , (select content7 from m003 where a.teacher_id = ti_id) , main_images , reg_date1 , reg_date2 , cnt_progress , subject_level , ncs_code , ncs_name , after_money , company_down , company_up , cnt_Work , cnt_note , cnt_test , progress_score , per_test , per_work , per_note , teacher_id FROM l000 a WHERE is_Del = 'no' AND lec_num = 1001