Skip to Content (Press Enter)
UserImage.jpg
Tmlewin .
7Views
2Comments
compound table calculation
Question
i have two tables..

TABLE A
produtcttype      Name         Quantity   CustomerName
GA                     pencil           5             Pat              
GA                     Pen               4             Charles           
RZ                      Ruler              3           Charles     


TABLE B

producttype          Name         Quantity       CustomerName                                         
GA                        Tablet            6               Charles                                               
RZ                         Iphone           7               Pat


Main Table
CustomerName            TotalQuantity     ProductType
Charles                               x                       GA


so guys how can i automatically derive the sum of the total quantity of items for charles across both tables for producttype  GA for example.Thanks .
0
0
05 Mar 2016
Copy Link
2015-05-05 17-20-51
João Santos
Hi Tmlewin,

With an Aggregate, you can compute automatically the total quantity of items for Charles in Table A.
I would say the easiest solution is to use two aggregates, one for Table A and another for B.

To really do it in one go, you would need an Advanced Query with an Union SQL statement.

Joao
0
0
07 Mar 2016
Copy Link
UserImage.jpg
Tmlewin .
yeap thanks. i have solved it with an advanced query.
0
0
07 Mar 2016
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.