SELECT
o.order_user_id,
o.order_time,
og.rec_id,
og.goods_id,
og.goods_num,
og.goods_price,
og.goods_cost,
og.goods_riginal_price,
g.goods_sn,
g.goods_category,
g.goods_name,
g.goods_pinyin
FROM
ambaby_order AS o
RIGHT JOIN ambaby_order_goods AS og ON og.ord_id = o.order_id
RIGHT JOIN ambaby_goods AS g ON og.goods_id = g.goods_id
WHERE
`order_user_id` = '1' AND
( g.`goods_name` LIKE '%00026%'
OR g.`goods_sn` = '00026'
OR g.`goods_pinyin` = '00026')今天工作时遇到个问题想了半天都不知怎么写成tp的连贯查询，求高手解答下 最佳答案
13078408107
积分：255
等级：LV1
热点推荐