strawberry help!!



"Eugenio Zinga" <eugzinga@tin.it> ha scritto nel messaggio
news:467ba496$0$4791$4fafbaef@reader4.news.tin.it. ..
>
> "strawberry" <zac.carey@gmail.com> ha scritto nel messaggio
> news:1182505502.442836.295500@c77g2000hse.googlegr oups.com...
>> On Jun 22, 8:52 am, "Eugenio Zinga" <eugzi...@tin.it> wrote:
>>> In the first place excused my English.
>>> I do not succeed to understand as the result of the query with 2 tables
>>> never is of the values mistakes to you while with 1 table the result is
>>> right.
>>> Thanks Eugene
>>>
>>> table ART:
>>> ------
>>> IDart
>>> 01
>>> 02
>>> 03
>>>
>>> table MOV1:
>>> -------
>>> IDart qta
>>> 01 100
>>> 02 100
>>> 03 100
>>> 01 100
>>> 03 50
>>>
>>> query1:
>>> SELECT IDart, SUM(MOV1.qta) as TMOV1
>>> FROM ART
>>> LEFT JOIN MOV1 ON ART.IDart = MOV1.IDart
>>> GROUP BY ART.IDart
>>>
>>> result query OK:
>>> IDart TMOV1
>>> 01 200
>>> 02 100
>>> 03 150
>>>
>>> ==================================
>>>
>>> table MOV2:
>>> -------
>>> IDart qta
>>> 01 10
>>> 02 30
>>> 03 20
>>> 01 10
>>> 03 5
>>>
>>> query2:
>>> SELECT IDart, SUM(MOV1.qta) as TMOV1, SUM(MOV2.qta) as TMOV2
>>> FROM ART
>>> LEFT JOIN MOV1 ON ART.IDart = MOV1.IDart
>>> LEFT JOIN MOV2 ON ART.IDart = MOV2.IDart
>>> GROUP BY ART.IDart
>>>
>>> result query NO OK:
>>> IDart TMOV1 TMOV2
>>> 01 8210 ? 10000 ?
>>> 02 3200 ? 9300 ?
>>> 03 1720 ? 4000 ?
>>
>> Query:
>>
>> SELECT ART.IDart, SUM(MOV1.qta) as TMOV1, SUM(MOV2.qta) as TMOV2
>> FROM ART
>> LEFT JOIN MOV1 ON ART.IDart = MOV1.IDart
>> LEFT JOIN MOV2 ON ART.IDart = MOV2.IDart
>> GROUP BY ART.IDart
>>
>> Result:
>>
>> IDart TMOV1 TMOV2
>> 1 400?? 40 ??
>> 2 100 30
>> 3 300 50
>>
> Thanks for your answer. How you see the total of code 1 is mistaken like
> never?
> IDart TMOV1 TMOV2
>> 1 200 20 Ok
>> 2 100 30
>> 3 300 50
>
>