选择内部或外部连接 [英] Select with Inner or Outer joins

问题描述

你好，

我有一张文章：

Hello,
I have a table of articles:

ID_ART CODE_ART
1       AAA
2       BBB
3       CCC
4       DDD
5       EEE

和表格小说：

And a Table Mouvements:

ID_SOR	ID_ART	QUANTITY_SOR	PRICE_SOR	QUANTITY_SOR * PRICE_SOR
1	1	1	           25.23	25.23
2	1	5	           22.51	112.55
3	2	1	              15	15
4	4	8	               5	40
5	4	2	             5.6	11.2
6	4	4	             5.3	21.2
7	2	2	            14.5	29

我想有一张表，它由ID_ART进行总和（QUANTITY_SOR * PRICE_SOR）分组，并且必须与CODE_A一起使用来自表格文章：

I would like to have a table wich do the sum(QUANTITY_SOR * PRICE_SOR) grouping by ID_ART and must be with the CODE_A from the table Articles:

ID_ART	CODE_ART	SUM(QUANTITY_SOR * PRICE_SOR)
1	     AAA	137.78
2	     BBB	44
4	     DDD	72.4

我尝试了几种没有结果的select语句。

Best Regrads。

I tried with several kinds of select statements without result.
Best Regrads.

推荐答案

您好



这是您的解决方案问题



选择p.code_art，sum（s.Quantity_sor * s.Price_sor）为总计

来自文章s加入Mouvements p on s.ID_ART = p.ID_ART

group by p.code_art





不要忘记将此标记为答案，如果它可以解决您的问题



问候

Mubin

Hi

Here is solution to your problem

select p.code_art ,sum(s.Quantity_sor * s.Price_sor ) as total
from articles s join Mouvements p on s.ID_ART=p.ID_ART
group by p.code_art


Do not forget to mark this as answer ,if it solves your problem

Regards
Mubin

嘿那里，



我复制了你的场景，这会得到你的结果。

Hey there,

I replicated your scenario and this will get you your result.

SELECT a.ID_ART, a.CODE_ART, SUM(m.QUANTITY_SOR * m.PRICE_SOR) FROM mouvements m
inner join articles a on a.ID_ART = m.ID_ART
group by a.ID_ART, a.CODE_ART

干杯。



Azee ...

Cheers.

Azee...

选择Table1.ID_ART，

Code_Art，

SUM（QUANTI TY_SORPRICE_SOR）AS&＃39; SUM（QUANTITY_SOR * PRICE_SOR）

来自表1

内连接表2

ON Tabe1.ID_ART = Table2。 ID_ART

Group by Table1.ID_ART，CODE_ART

Select Table1.ID_ART,
Code_Art,
SUM(QUANTITY_SORPRICE_SOR) AS 'SUM(QUANTITY_SOR *PRICE_SOR)
From Table1
inner join Table2
ON Tabe1.ID_ART = Table2.ID_ART
Group By Table1.ID_ART,CODE_ART

这篇关于选择内部或外部连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！