请问一下这个左键连接会导致模糊查询失败吗,兄弟姐妹们
SELECT * FROM (
SELECT
rank,
a.id,
a.inspection_request_no,
a.inspection_report_no,
a.inspection_lot_number,
a.inspection_contents,
a.inspection_type,
a.inspection_person,
a.is_qualified,
a.inspection_state,
a1.material_description_cn inspection_material_number,
a.create_by,
a.create_time,
a.update_by,
a.update_time
FROM
(
SELECT
@rownum := @rownum + 1 AS rank,
inspection_report.*
FROM
( SELECT @rownum := 0 ) id,
inspection_report
ORDER BY
create_time
) a
LEFT JOIN material a1 ON a.inspection_material_number = a1.id
) a