Hello,
I have created 3 tables:
1. GSM (stored the user name)
2. Voice_Plans (stored both PLAN Number and Charges of the Plan)
3. Phones (stored Device Name and Charges of the Device
In the GSM table
- I have a Lookup field linked to `Voice_Plans`.`Charges`
- and I have another Lookup field linked to `Phones`.`Charges`
- and created another field with name TOTAL (to show the total of the above two fields that are linked to another two tables)
in CALCULATED FIELD I have entered the following SQL command:
SELECT (`Voice_Plans`.`Charges` + `Phones`.`Charges`) FROM Voice_Plans, Phones WHERE id='%ID%'
but I am not getting the TOTAL of the above two fields, so I am wondering;
1. If what I am intending to do is possible in Calculated Field
2. secondly, is the command correct ?
SUM of Two Columns from Two Different Table
SUM of Two Columns from Two Different Table
THANK YOU...
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course
Re: SUM of Two Columns from Two Different Table
Hi,
1, yes,
2, no
Without knowing the details of your tabledefinitons it is not possible to provide further help.
The sum is correct, but you need to join the 3 tables together based on the linked fields.
1, yes,
2, no
Without knowing the details of your tabledefinitons it is not possible to provide further help.
The sum is correct, but you need to join the 3 tables together based on the linked fields.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: SUM of Two Columns from Two Different Table
HI pböttcher,
You enjoy torturing me, isn't it?!
No worries, thanks for your comments and confirmation that it is possible
I am pushing Mr. GOOGLE to find me the solution or at least some hints, as SQL is not my play ground
You enjoy torturing me, isn't it?!
No worries, thanks for your comments and confirmation that it is possible
I am pushing Mr. GOOGLE to find me the solution or at least some hints, as SQL is not my play ground
THANK YOU...
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course