为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:win10
【CPU】:
【问题描述】:无效的表或视图名[VM_RESUME_LIBRARY]
sql语句:SELECT
vi.,
vrl.NAME,
vrl.sex,
vrl.birth_date AS birthDate,
vrl.person_native AS personNative,
vrl.phone,
vrl.email,
vrl.education,
vrl.education_type AS educationType,
vrl.specialty,
vrl.graduate_date AS graduateDate,
vrl.expect_position AS expectPosition,
vrl.arrive_date AS arriveDate,
vrl.resume_attachments AS resumeAttachments,
TIMESTAMPDIFF( YEAR, vrl.graduate_date, DATE_FORMAT( NOW( ), ‘%Y-%m-%d %H:%i:%S’ ) ) AS seniorYear,
vrl.school,
vp.position_name AS positionName,
vp.work_site AS workSite,
vp.work_year AS workYear,
vp.education AS positionEducation
FROM
vm_interview vi
LEFT JOIN vm_resume_library vrl ON vrl.id = vi.resume_id
LEFT JOIN vm_position vp ON vp.id = vi.position_id
WHERE
vi.is_delete = 0
ORDER BY
vi.create_date DESC
报错很明确啊,这个表或视图找不到,确认在当前用户的默认模式下是否存在,确认大小写是否敏感,对象名是否完全一致