1. 查询所有iPhone 6s的入库信息

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;