Log In
Register
Home
merge in PQ
Irena Gofman
New Member
Members
Forum Posts: 2
Member Since:
August 25, 2019
August 25, 2019
Offline1
August 25, 2019 - 5:40 pm
Hello, I have 3 tables:
In table 1 I have the sum price of the product that name is 'ORANGE". The number of product is 201619038.
| name | number | sum |
| orange | 201619038 | 95,608.13 |
In table 2 I have the sum price of the same product that name 'ORANGE" but it appears in two lines. The total result is the same 95,608.13.
| name | number | sum |
| orange | 96395665 | 91,575.50 |
| orange | 967844 | 4,032.63 |
| total | 95,608.13 |
In table 3 I have Conversion Table for number of product:
| name | the number in table 1 | the number in table 2 |
| orange | 201619038 | 96395665 |
| orange | 201619038 | 967844 |
The question is: how can I do the merge of table 1 & 2 if I have to get to the result like this:
| name | from table 1number | sum | from table 2 number | sum | difference |
| orange | 201619038 | 95,608.13 | 96395665 | 91,575.50 | 4,032.63 |
| orange | 201619038 | 967844 | 4,032.63 | -4,032.63 |
Thank you in advance
See Answer
Mynda Treacy
Admin
Forum Posts: 4772
Member Since:
July 16, 2010
July 16, 2010
Offline2
August 26, 2019 - 8:49 am
Hi Irena,
Please see the attached file. However, the sum of 95,608.13 relates to the table from 1number 201619038, not the number in table two; 96395665 and therefore it is on both rows in the final table. There is no logical way you can avoid this for the second row and return a blank, as you have in your example.
Mynda
Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 5
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 930
Purfleet: 415
Hans Hallebeek: 354
Frans Visser: 349
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
QkBXoylJZ ionivxwYdRFNFL
kEUeirrVvEo LuuDySmTmIizW
uavBfwotTrMPA NIQkZzprwMG
qVMPnaSzpgZ uaHBwyav
rCkwbAORdf eaYibAkYjfXT
eNvhcbgYvaPRp nImfgnjOk
kwKbBpnpPjgKuhr LSOUORDzhcRqQ
CPUXMYKMkLuXs iAsOmBtNLn
Clive Webb
EXerOrqW PRqmMlMeyNd
Forum Stats:
Groups: 3
Forums: 25
Topics: 7095
Posts: 31105
Member Stats:
Guest Posters: 49
Members: 34537
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —