공단검진결과입력

공단검진결과입력

List

관리자 > 공단검진결과입력

   

select count(*) as cnt from checkup_reser as a left join xe_member as b on a.user_id=b.user_id left join kw_check as c on b.employee_number=c.employee_number where c.2015_check='1' and rdate >= '2015-02-01' and rdate <= '2019-07-20' and (price ='0' || tr<>'0') and and cen_ok='Y'

1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and cen_ok='Y'' at line 1

error file : /checkh/result2_list.php

번호 검진센터명 검진자명 기업명 생년월일 선택검진항목 추가검진항목 연락처 예약일 등록일 예약확인