SELECT FROM hospital_view hvJOIN department de ON hvdepartment_id = deidWHERE destatus = 1写出上面两个表联查写出查询出科室的状态为0的sql语句加上模糊查询和limit

SELECT * FROM hospital_view hv JOIN department de ON hv.department_id = de.id WHERE de.status = 1

SELECT * FROM hospital_view hv JOIN department de ON hv.department_id = de.id WHERE de.status = 0 AND (de.name LIKE '%keyword%' OR de.description LIKE '%keyword%') LIMIT 10