SELECT
pname,
rid,
product.pid,
vid,
rprice,
rcount,
returncount,
rdecp,
rdate
FROM
(
SELECT
*
FROM
product
WHERE
pname = 'iPhone 6s'
) AS product
INNER JOIN recruit ON product.pid = recruit.pid;
1. 查询所有iPhone 6s的入库信息
最新推荐文章于 2021-06-12 00:11:41 发布