sql如下：
SELECT
t.*,d.name as "workName"
FROM
t_traceability_slice t
LEFT JOIN sys_department d ON t.workshop_code = d.code
WHERE
t.del_flag = '0'
AND t.enterprise_id = 81
AND ( t.production_Batch LIKE '%B463463543525%' OR t.import_Batch LIKE '%B463463543525%' )
原因分析：由于sys_department表id字段没有设置为主键，不管是内连接，左连接还是右连接，只要查询sys_department表，就会查出两条记录。