|
|
 |
 |
| |
|
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 = '4' AND a.clYN = 'Y' AND a.clCODE in (SELECT clCODE FROM paTBL WHERE paDIV='P' GROUP BY clCODE) AND a.clDIV = 'REVIEW' 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 = '4' AND a.clYN = 'Y' AND a.clCODE in (SELECT clCODE FROM paTBL WHERE paDIV='P' GROUP BY clCODE) AND a.clDIV = 'REVIEW' ORDER BY a.clSEQ
|
|
|
