请问一下这个左键连接会导致模糊查询失败吗,兄弟姐妹们 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