服务器未知运行时异常: 
### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Unknown column 'cs.id' in 'on clause'
### The error may exist in file [D:\cz\203\徐州计量\code\casic-metering\casic-metering-dao\target\classes\mapper\business\BusinessSiteExecutiveLogMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT(*) FROM (SELECT         sel.id as id,sel.log_name AS logName,su.name  AS recorderName,lab.organize_name as laboratoryName,sel.executive_address as executiveAddress,sel.log_no as logNo,record_time AS recordTime,sel.create_time AS createTime,customerName         FROM         business_site_executive_log sel         LEFT JOIN(             SELECT  customerName,id             FROM business_site_executive_info             JOIN(                 SELECT customer_name AS customerName                 FROM customer_info                                )cs ON  customer_id=cs.id             WHERE is_del = 0         ) bsei ON bsei.id = sel.site_executive_id         LEFT JOIN (                SELECT id, organize_name                FROM meter_organize                WHERE is_del = 0 AND is_lab = 1                ) lab ON lab.id = sel.laboratory_id         LEFT JOIN sys_user su ON su.id = sel.recorder where 1=1                                       order  by sel.update_time desc) TOTAL
### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'cs.id' in 'on clause'
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'cs.id' in 'on clause'