<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.njcn.gather.icd.mapper.PqIcdPathMapper">


    <select id="selectIcdByDevType" resultType="com.njcn.gather.icd.pojo.po.PqIcdPath">
        select *
        from pq_icd_path path
                 inner join pq_dev_type type on path.id = type.icd
        where type.id = #{devTypeId}
    </select>
</mapper>

