查goods.id，goods.goods_name，goods.short_name，goods.labels
要求每一個goods_id對應相應的goods.goods_name，goods.short_name，goods.labels
下面是自己寫的，我知道肯定不對
望大神們指點
select `groupbuy_goods`.`id`, `groupbuy_goods`.`goods_name`, `groupbuy_goods`.`short_name`, `groupbuy_goods`.`labels` from `groupbuy_group_buy_goods` left join `groupbuy_goods` on `groupbuy_goods`.`id` = `groupbuy_group_buy_goods`.`goods_id` where (`groupbuy_goods`.`tenant_id` = ? and `groupbuy_goods`.`type` = ?) and `groupbuy_group_buy_goods`.`group_buy_id` = ?
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/46782.html
標籤：MySQL
上一篇：R軟體BayesianStat包 Normgd函式報錯應該怎么調整
下一篇：急求DB2動態行轉列（在線等）