从SQL中的一些表中获取值 [英] Getting values from a few tables in SQL
本文介绍了从SQL中的一些表中获取值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,
我有一个客户,他们想从SQL获取报告.该报告从采石场获取每月总平方米和总案例.
Hello guys,
I have a customer that they want to get a report from SQL. The report is getting monthly total sqm and total cases from quarries.
The table: INBOUND
The columns of INBOUND: Product_ID, Sqm, Qantity of Case, Production Date
The table: OUTBOUND
The columns of OUTBOUND: Product_ID, Sqm, Qantity of Case, Delivery Date
The Table: QUARRIES
The Columns of QUARRIES: Quarry_ID, Quarry
The Table: PRODUCTS
The Columns of PRODUCTS: Product_ID, Quarry_ID
SELECT O.QUARRY, SUM(I.M2) AS INBOUND_TOTAL, SUM(I.Qantity_of_Case) AS TOTAL_CASE
FROM PRODUCTS U, QUARRY O, INBOUT I
WHERE U.PRODUCT_ID=OT.PRODUCT_ID AND O.QUARRY_ID=U.QUARRY_ID
AND MONTH(I.PRODUCTION_DATE)=5 AND YEAR(I.PRODUCTION_DATE)=2012
GROUP BY O.QUARRY
SELECT O.QUARRY, SUM(OT.M2) AS INBOUND_TOTAL, SUM(OT.Qantity_of_Case) AS TOTAL_CASE
FROM PRODUCTS U, QUARRY O, OUTBOUND OT
WHERE U.PRODUCT_ID=OT.PRODUCT_ID AND O.QUARRY_ID=U.QUARRY_ID
AND MONTH(OT.DELIVERY_DATE)=5 AND YEAR(OT.DELIVERY_DATE)=2012
GROUP BY O.QUARRY
感谢您的帮助...
Haluk
Thanks for helping...
Haluk
推荐答案
u可以使用联合会解决您的问题
u can use union it will solve your problem
请在下面的查询中尝试
try below query
SELECT O.QUARRY, SUM(I.M2) AS INBOUND_TOTAL, SUM(I.Qantity_of_Case) AS TOTAL_CASE
FROM PRODUCTS U, QUARRY O, INBOUT I
WHERE U.PRODUCT_ID=OT.PRODUCT_ID AND O.QUARRY_ID=U.QUARRY_ID
AND MONTH(I.PRODUCTION_DATE)=5 AND YEAR(I.PRODUCTION_DATE)=2012
GROUP BY O.QUARRY
union
SELECT O.QUARRY, SUM(OT.M2) AS INBOUND_TOTAL, SUM(OT.Qantity_of_Case) AS TOTAL_CASE
FROM PRODUCTS U, QUARRY O, OUTBOUND OT
WHERE U.PRODUCT_ID=OT.PRODUCT_ID AND O.QUARRY_ID=U.QUARRY_ID
AND MONTH(OT.DELIVERY_DATE)=5 AND YEAR(OT.DELIVERY_DATE)=2012
GROUP BY O.QUARRY
这篇关于从SQL中的一些表中获取值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文