我需要该查询的解决方案吗? [英] I Need The Solution Of this Query?

问题描述

我有两个表发送和加工
表发送
-------------
IID目的地从目的地到重量(公斤)
---------------------------------------------
1德里果阿50
2德里加尔各答60
3德里果阿70
4德里加尔各答80
5加尔各答新德里90
6果阿加尔各答20
7果阿德里10
8果阿德里20
9果阿加尔各答15
10加尔各答德里5

第二表(处理中)
--------------------
pid iid金额
----------------------------------------------
1 1 55
2 1 60
3 2 54
4 2 60
5 3 58
6 4 10
7 4 20
8 4 15
9 4 10
10 5 50
11 5 60
12 5 75
13 6 15
14 6 35
15 7 15
16 8 30
17 8 12
18 9 30
19 9 45
20 10 25


与处理相关联的发货的ID，它是
中的主键 寄发

现在我想要什么
这两个表中的Dest_From，Dest_To，sum(weight)，sum(Amount)以及Dest_From，Dest_To中的分组

解决方案

您需要使用JOIN和GROUP BY.

它应该看起来像这样:

SELECT what_you_need_to_select FROM Despatch AS d
INNER JOIN Processing AS p ON d.iid = p.iid
GROUP BY your_group

尝试以下查询


从发送和处理中选择Dest_From，Dest_To，Sum(weight)，Sum(Amount)，其中Despatch.iid = Processing.iid分组依据(Dest_From，Dest_To，Sum(weight)作为Sweight，Sum(Amount)作为Samount)

I have Two Tables Despatch & Processing
Table Despatch
-------------
IID Dest From Dest To Weight(In Kg)
---------------------------------------------
1 Delhi Goa 50
2 Delhi Kolkata 60
3 Delhi Goa 70
4 Delhi Kolkata 80
5 Kolkata Delhi 90
6 Goa Kolkata 20
7 Goa Delhi 10
8 Goa Delhi 20
9 Goa Kolkata 15
10 Kolkata Delhi 5

2nd Table(Processing)
--------------------
pid iid Amount
----------------------------------------------
1 1 55
2 1 60
3 2 54
4 2 60
5 3 58
6 4 10
7 4 20
8 4 15
9 4 10
10 5 50
11 5 60
12 5 75
13 6 15
14 6 35
15 7 15
16 8 30
17 8 12
18 9 30
19 9 45
20 10 25


iid of despatch linked with processing and it is primary key in
despatch

Now What I want
Dest_From,Dest_To,sum(weight),sum(Amount) From These Two Tables and With Grouping In Dest_From,Dest_To
Through A Query Is It Possible?

解决方案

You need to use JOIN and GROUP BY.

It should look something like this:

SELECT what_you_need_to_select FROM Despatch AS d
INNER JOIN Processing AS p ON d.iid = p.iid
GROUP BY your_group

Try Following Query


Select Dest_From,Dest_To,Sum(weight),Sum(Amount) from Despatch and Processing where Despatch.iid=Processing.iid Group By(Dest_From,Dest_To,Sum(weight) as Sweight ,Sum(Amount) as Samount)

这篇关于我需要该查询的解决方案吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！