回一楼,应该不是的,我将”WHERE crea_date>#10/1/2002# And crea_date<#10/31/2002#“这句去掉,查询全年所有商品是对的。
TO qing39(阿Q): 就算我查询的时候限制了1个月,但是用左连接后,所有商品都应该显示吧,最多有些商品的”数量“,”单价“,”金额“为NULL
SELECT A.pdt_name AS 商品名称, B.quantity AS 数量, B.price AS 单价, B.cnt AS 金额 FROM PDT_TABLE as A LEFT JOIN (SELECT PDT_ID, sum(quantity) AS quantity, sum(cnt)/sum(quantity) AS price, sum(cnt) AS cnt FROM XSFP_TABLE WHERE crea_date>="2002-10-1" And crea_date=<"2002-10-31" GROUP BY pdt_id) as B on A.pdt_id = B.pdt_id
就算我查询的时候限制了1个月,但是用左连接后,所有商品都应该显示吧,最多有些商品的”数量“,”单价“,”金额“为NULL
FROM PDT_TABLE as A LEFT JOIN
(SELECT PDT_ID, sum(quantity) AS quantity, sum(cnt)/sum(quantity) AS price, sum(cnt) AS cnt
FROM XSFP_TABLE
WHERE crea_date>="2002-10-1" And crea_date=<"2002-10-31"
GROUP BY pdt_id) as B
on A.pdt_id = B.pdt_id
不要计算列也不行。
按照你的做法是对的,但是您能解释一下吗?谢谢
WHERE (crea_date>#10/1/2002# And crea_date<#10/31/2002#) or crea_date is null