|
|
HOME > ¼ö°½Åû > On-line ¼ö°½Åû> Á¾ÇÕ¹Ý ¼ö°½Åû |
|
|
|
|
SELECT a.clCODE, a.clNAME, a.clPRICE, a.clPERIOD, a.clSUBs, a.clSAMPLE, b.teNAME, c.paSYNCname, a.clPRICEbo, a.clIMG, a.clTeachTime, a.clLowVod, a.clCATE, a.clMeter, a.clPKGMETER, a.clHD, a.clHDlow, a.clPRICEm, a.mobile_yn, a.mobile_lec, a.clSeparateMOBILE FROM clTBL A LEFT JOIN teTBL B on A.clTEACHER=B.teCODE left join paTBL C on (A.clCODE=C.paSYNCcode ) WHERE a.liCODE = '3' AND a.clYN = 'Y' AND a.clCODE in (SELECT clCODE FROM paTBL WHERE paDIV='P' GROUP BY clCODE) AND a.clDIV = 'ÆÐÅ°Áö' ORDER BY a.clSEQ SELECT a.clCODE, a.clNAME, a.clPRICE, a.clPERIOD, a.clSUBs, a.clSAMPLE, b.teNAME, c.paSYNCname, a.clPRICEbo, a.clIMG, a.clTeachTime, a.clLowVod, a.clCATE, a.clMeter, a.clPKGMETER, a.clHD, a.clHDlow, a.clPRICEm, a.mobile_yn, a.mobile_lec, a.clSeparateMOBILE FROM clTBL A LEFT JOIN teTBL B on A.clTEACHER=B.teCODE left join paTBL C on (A.clCODE=C.paSYNCcode ) WHERE a.liCODE = '3' AND a.clYN = 'Y' AND a.clCODE in (SELECT clCODE FROM paTBL WHERE paDIV='P' GROUP BY clCODE) AND a.clDIV = 'ÆÐÅ°Áö' ORDER BY a.clSEQ
|
|
|
|
1. µ¿¿µ»ó ¼ÓµµÁ¶Àý±â´É Áö¿ø
2. ¿ÀÇÁ¶óÀΰú µ¿ÀÏÇÑ ¼ºñ½º Á¦°ø (´Ü, ¼ö¾÷Âü¼® ºÒ°¡)
3. ¿Â¶óÀÎ ÇÐÁ¡ Ãëµæ°ú ÀÀ½Ã¿ø¼ ¾÷¹«´ëÇà ¹× °³Àκ° ¹ÐÂø°ü¸®
4. ¸ÆºÏ ¼ö° °¡´É
5. Á¤±âÀûÀÎ °ÀÇ ¾÷µ¥ÀÌÆ® ÁøÇà (±³Àç º¯°æ½Ã Ãß°¡±¸¸ÅÇØ¾ß ÇÔ)
6. ÀÎÅÍ³Ý Ä«µå°áÁ¦ °¡´É (¹«ÀÌÀÚ °¡´É. ¿¬Áß¹«ÈÞ. ±¹Á¦¹è¼Û·á Æ÷ÇÔ °áÁ¦°¡´É)
7. °ú¸ñº° °»ç´Ô²² Áú¹® ¹× ´äº¯°¡´É
8. ÇØ¿Ü¿¡¼ ÀÎÅÍ³Ý µ¿¿µ»ó ¼ö°°¡´É
* µ¿ÀÏ °úÁ¤ Àçµî·Ï½Ã Ãß°¡ÇÒÀÎ ÇýÅÃÁ¦°ø.
* ¸ð¹ÙÀÏ ±â±â ¼ºñ½º °¡´É (ÅÇ, ÆÐµå µî ¿ù 20,000¿ø À¯·á¼ºñ½º)
|
|
|
|
|
|
|
|
|
|
|
|
|
|