springboot-mysql多表联合查询
<select id="queryAllProducts" resultType="ProductInfo">
SELECT product_info.*,type.name as typeName FROM product_info
INNER JOIN type ON product_info.tid = type.type_id;
</select>
<select id="queryAllProducts" resultType="ProductInfo">
SELECT product_info.*,type.name as typeName FROM product_info
INNER JOIN type ON product_info.tid = type.type_id;
</select>