从SQL中的一些表中获取值 [英] Getting values from a few tables in 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屋！