충남대학교

SELECT DATA.SEQ, DATA.NAME, CP.CORP_NAME, CL.DEPT, (SELECT COUNT(*) FROM COMMUTE WHERE SEQ_STU = DATA.SEQ AND SEQ_LECT = '' AND IN_STATE = '정상출근') AS IN_G, (SELECT COUNT(*) FROM COMMUTE WHERE SEQ_STU = DATA.SEQ AND SEQ_LECT = '' AND IN_STATE = '지각') AS IN_E, (SELECT COUNT(*) FROM COMMUTE WHERE SEQ_STU = DATA.SEQ AND SEQ_LECT = '' AND OUT_STATE = '정상퇴근') AS OUT_G, (SELECT COUNT(*) FROM COMMUTE WHERE SEQ_STU = DATA.SEQ AND SEQ_LECT = '' AND OUT_STATE = '조퇴') AS OUT_E, (SELECT COUNT(*) FROM COMMUTE WHERE SEQ_STU = DATA.SEQ AND SEQ_LECT = '' AND ETC != '') AS ETC FROM ( SELECT SEQ, SEQ_CORP, SEQ_CLASS, NAME FROM MEMBER_STUDENT WHERE SEQ_ ='' AND SEQ_LECT = '' UNION SELECT SEQ_ORI AS SEQ, SEQ_CORP, SEQ_CLASS, NAME FROM MEMBER_STUDENT_HISTORY WHERE SEQ_ ='' AND SEQ_LECT = '' ORDER BY SEQ DESC ) DATA, member_corp CP, member_class CL WHERE CP.seq = DATA.SEQ_CORP AND CL.seq = DATA.SEQ_CLASS

1054 : Unknown column 'SEQ_' in 'where clause'

error file : /cc/html/location.php