简单的一对多的sql查询
标签：join sql查询 div class name cat 数据查询 sel style
简单的一对多的sql查询
b.id,
b. NAME,
COUNT(b.id) AS catNum
FROM
jc_goods_brand b
LEFT JOIN jc_goods_cat c ON b.id = c.goods_brand_id
GROUP BY
b.id