我在mysql中直接写语句:
SELECT
bgb.goods_num,
bgb.goods_type_icon,
bgb.goods_id,
bgb.goods_name,
bgb.goods_sort,
bgt.type_name,
bgs.style_name,
bgbr.brand_name,
bgb.goods_code,
bgb.is_shelf,
(select sum(sku_sale_count) from busi_goods_sku AS bgsku WHERE bgb.goods_id=bgsku.goods_id) as sale_count
FROM
busi_goods_base AS bgb
LEFT JOIN busi_goods_type AS bgt ON bgb.goods_type_id=bgt.type_id
LEFT JOIN busi_goods_style AS bgs ON bgb.goods_style_id=bgs.style_id
LEFT JOIN busi_goods_brand as bgbr ON bgb.goods_brand_id=bgbr.brand_id
WHERE
bgb.is_del=0
ORDER BY
sale_count DESC
是 可以进行查询的,但是把它放到mybatis的mapper.xml中,运行的时候会报错