主表
从表
SQL(查询所有主表的数据同时统计另一张表的与主表关联的数据)
select go.*,(select count(cc.id) from cook_comment as cc where cc.goodsId=go.id) as commentNumber from goods as go ;
主表
从表
SQL(查询所有主表的数据同时统计另一张表的与主表关联的数据)
select go.*,(select count(cc.id) from cook_comment as cc where cc.goodsId=go.id) as commentNumber from goods as go ;