原先的SQL:
SELECT md.repertory,
md.mid,
md.status,
m.pic,
m.name,
m.selling_price,
m.vendor,
mp.property_value,
mp2.property_value AS gyzz, 这两个在数据库中查询时不一致,,但在Hibernate中查询出来结果一样
md.did,
md.id,
(CASE md.retail_price
WHEN NULL THEN 0.00
ELSE md.retail_price
END) AS retail_price
FROM yk_medicine_drugstore md
INNER JOIN yk_medicine m
ON m.id = md.mid
INNER JOIN yk_medicine_property_detail mp
ON mp.medicine_id = md.mid
AND mp.property_id = 6
INNER JOIN yk_medicine_property_detail mp2
ON mp2.medicine_id = md.mid
AND mp2.property_i
SELECT md.repertory,
md.mid,
md.status,
m.pic,
m.name,
m.selling_price,
m.vendor,
mp.property_value,
mp2.property_value AS gyzz, 这两个在数据库中查询时不一致,,但在Hibernate中查询出来结果一样
md.did,
md.id,
(CASE md.retail_price
WHEN NULL THEN 0.00
ELSE md.retail_price
END) AS retail_price
FROM yk_medicine_drugstore md
INNER JOIN yk_medicine m
ON m.id = md.mid
INNER JOIN yk_medicine_property_detail mp
ON mp.medicine_id = md.mid
AND mp.property_id = 6
INNER JOIN yk_medicine_property_detail mp2
ON mp2.medicine_id = md.mid
AND mp2.property_i