SELECT
*
FROM
product,
recruit
WHERE
rdate > '2016-10-31'
AND rdate < '2016-12-01'
AND product.pid = recruit.pid;
6. 使用左连接查询2016年11月份入库的所有商品名及入库情况
最新推荐文章于 2022-12-07 22:12:42 发布
SELECT
*
FROM
product,
recruit
WHERE
rdate > '2016-10-31'
AND rdate < '2016-12-01'
AND product.pid = recruit.pid;