mysql 三个表的联合查询问题

2025-02-06 11:16:14
推荐回答(1个)
回答1:

$sql ="select c.goods_name from c left join b on b.goods_id=c.goods_id left join a on a.goods_id=c.goods_id where a.isbest=0 and b.cat_id="B"";