SQL Command Help to Total Row by Row using 3 Tables with MySQL using "AppGini". Software

Completed Posted 3 years ago Paid on delivery
Completed Paid on delivery

I have created 3 tables in MySQL

Table1 has two Lookup Fields,

- 1st Field "Charges" linked to "Charges" Field in Table2

- while 2nd Field in Table1 Linked to "Charges" Field of Table3.

- and created 3rd Field in Table1 named "TOTAL"

➡️ the Project is to get the Total of [login to view URL] + [login to view URL] in [login to view URL]

➡️ This SQL calculation must be added to "Calculated Fields" of [login to view URL]

which is the place you enter the SQL command to get the Total Row by Row

Please note that I am using the software "AppGini" the code generator (using PHP) with MySQL

You can refer to Calculated Field feature here

[login to view URL]

Please let me know...

Thank you...

MySQL SQL

Project ID: #27562278

About the project

10 proposals Remote project Active 3 years ago

Awarded to:

(27 Reviews)
4.1

10 freelancers are bidding on average $32 for this job

kholmogorovadev

Hello, I am MySql expert I can help you very well I'll note you are using software 'AppGini' the code gennerator. I have checked your exmple. please let me know regards Alexandra

$30 USD in 7 days
(11 Reviews)
5.4
dnplugins

Can you provide structure of your table and possibly a visual representation of your table relationships so I can understand it more clearly. I have been a website developer for more than 6 years, previously working f More

$30 USD in 1 day
(24 Reviews)
4.1
SqlDevelopment

I can develop required MySQL query to calculate a totals. I am highly-qualified SQL developer with more than 10 years of database development experience and can deliver a solution in a most efficient way.

$45 USD in 1 day
(23 Reviews)
4.2
mabmojo

Hi client, I am very interested in this project. I have a lot of experience in SQL QUERY for over 10 years. If you have any questions or concerns don't hesitate to let me know. I hope to hear from you. Best regards More

$30 USD in 1 day
(3 Reviews)
2.3
TheGDs

Hi, I am a pro DBA. I will write the desired queries that will sum the columns from linked fields into Total row by row. Ready to start.

$25 USD in 1 day
(4 Reviews)
2.4
farhan4262

Hi, I am a Full Stack developer with extensive experience in developing state of the art applications. I have 6+ years of experience in using databases. My working style is simple and following are my steps. 1- Unde More

$30 USD in 1 day
(0 Reviews)
0.0
arturochiarella

Hey i can help you with the thing we can use PL/SQl, im a software engineer student on third year(4 years in total) i know a low of databases, querys and plsql

$20 USD in 1 day
(0 Reviews)
0.0