â¤Ã§ÊÃéÒ§ËÅÑ¡ÊÙµÃ
SELECT COURSEID, TYPE, CATEGORY, CODE, NAMEENG, NAMETHAI, CREDIT, MINGPA, MAXCREDIT,CREDITDESCRIPTION FROM ( SELECT -1 COURSEID, 0 TYPE, A.CONDITIONID CATEGORY, '' CODE, A.DESCRIPTION NAMEENG, A.DESCRIPTION NAMETHAI, TO_CHAR(A.CREDITTOTAL, '9999') CREDIT, MINGPA, MAXCREDIT, CREDITDESCRIPTION FROM AVSREG.PROGRAMSTRUCTURE A WHERE A.PROGRAMID=10013806 UNION SELECT B.COURSEID, 1 TYPE, A.CONDITIONID CATEGORY, B.COURSECODE CODE, B.COURSENAMEENG NAMEENG, B.COURSENAME NAMETHAI, B.COURSEUNIT CREDIT, 0 MINGPA, 0 MAXCREDIT, '' CREDITDESCRIPTION FROM AVSREG.COURSEINPROGRAM A, AVSREG.COURSE B WHERE A.PROGRAMID=10013806 AND A.COURSEID=B.COURSEID AND B.COURSESTATUS='O' ) GROUP BY CATEGORY, COURSEID, CODE, CREDIT, NAMEENG, NAMETHAI, MINGPA, MAXCREDIT, TYPE,CREDITDESCRIPTION ORDER BY CATEGORY, TYPE
 ¤³Ð : ï¿½ï¿½ï¿½ï¿½ï¿½Å»ï¿½ï¿½Êµï¿½ï¿½ï¿½ï¿½ï¿½ï¿½Ô·ï¿½ï¿½ï¿½ï¿½Êµï¿½ï¿½
 ÃдѺ¡ÒÃÈÖ¡ÉÒ : ï¿½ï¿½Ô­ï¿½Òµï¿½ï¿½(��º�͹/������ͧ)
 ËÅÑ¡Êٵà: ï¿½Ôµï¿½ï¿½ï¿½ÊµÃºÑ³ï¿½Ôµ
 ÊÒ¢ÒÇÔªÒ : -

ãªéàÁéÒÊì¤ÅÔ¡·ÕèÃËÑÊÇÔªÒà¾×èÍáÊ´§¤Ó͸ԺÒÂÃÒÂÇÔªÒ

          
äÁ辺¢éÍÁÙÅ·ÕèàÅ×Í¡
   
      
    - ¡ÒÃáÊ´§¼Å·ÕèàËÁÒÐÊÁá¹Ð¹ÓãËéãªé browser à»ç¹ Internet Explorer Version 5.0 ¢Öé¹ä»
      áÅТ¹Ò´¤ÇÒÁ¡Çéҧ˹éÒ¨Í (Screen Area) à»ç¹ 1024x768 pixels
        contact staff : ¡Í§Êè§àÊÃÔÁÇÔªÒ¡ÒÃáÅЧҹ·ÐàºÕ¹ â·ÃÈѾ·ì 0-4253-2477-8 µèÍ 405