查询数据走到 hosptal_id为0 devicetype有值 最终查询回出现错误。这是为什么呢。 我在navicat里面填充数据直接查也是可以的 SELECT DISTINCT checkitem.* FROM rims_reporting_image_review review LEFT JOIN rims_reporting_dictionary_checkitem checkitem ON review.checkitem_fk = checkitem.uuid WHERE review.devicetype_fk IN ("+split(devicetype,",")+") AND review.createtime BETWEEN "+datastart+" AND "+dataend+" AND review.agent_fk IN ( SELECT agent_uuid FROM view_permission_agent_erpreport WHERE username = "+username+" AND agent_state = 1 ) |