calculate the total revenue from the two databases
am 17.06.2011 09:09:53 von HaidarPesebe------=_NextPart_000_0027_01CC2CF8.3A8BBE10
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Please help calculate the total revenue from the two databases below. =
The first database is the name of the item and price. The second =
database is the goods sold. I will make a recapitulation of every month =
to my total income (total only). I've tried tp always failed.=20
TABLE A (item name and price)
------------------------------------------------------------
NO : CODE : NAME : PRICE(USD) :
------------------------------------------------------
1 : A01 : NAME A : 20
2 : A02 : NAME B : 15
-----------------------------------------------------
TABLE B (items sold)
------------------------------------------------------------ -------------=
--------
: NO : CODE : CITY : QTY : MONTH : YEAR :
------------------------------------------------------------ -------------=
------
: 1 : A01 : PARIS : 20 : 1 : 2011 :=20
: 2 : A01 : LONDON : 11 : 1 : 2011 :=20
: 3 : A02 : PARIS : 15 : 1 : 2011 :=20
: 4 : A02 : PARIS : 10 : 1 : 2011 :=20
: 5 : A01 : PARIS : 7 : 2 : 2011 :=20
: 6 : A01 : LONDON : 8 : 2 : 2011 :=20
: 7 : A02 : LONDON : 10 : 2 : 2011 :=20
------------------------------------------------------------ -------------=
-------
the result will be like this
NO : DATE (month year) : Total (USD)
-----------------------------------------------------------
1 : 1 - 2011 : 995
2 : 2 - 2011 : 450
Best regards,
Haidar
__________ Information from ESET NOD32 Antivirus, version of virus signatur=
e database 6215 (20110616) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
------=_NextPart_000_0027_01CC2CF8.3A8BBE10--