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

$10-30 USD

Finalizat

Data postării:

peste 3 ani în urmă

$10-30 USD

Plata la predare

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

ID-ul proiectului: 27562278

Despre proiect

10 propuneri

Proiect la distanță

Activ: 4 ani în urmă

Vrei să câștigi bani?

Adresa de e-mail

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal

Îți primești plata pentru serviciile prestate

Evidențiază-ți propunerea

Te înregistrezi și licitezi gratuit pentru proiecte

Acordat utilizatorului:

@jjbayliss

$0 USD în 7 zile

5,0

(27 recenzii)

4,1

10 freelanceri plasează o ofertă medie de $32 USD pentru proiect

@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 în 7 zile

5,0

(11 recenzii)

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 for a private company making administrative website and developer tools. I work with websites built with PHP, MySQL, Javascript, Wordpress, Laravel and more. Please feel free to send me a message so we can discuss further details. Thanks.

$30 USD în 1 zi

5,0

(24 recenzii)

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 în 1 zi

5,0

(23 recenzii)

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, Michael

$30 USD în 1 zi

5,0

(3 recenzii)

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 în 1 zi

5,0

(4 recenzii)

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- Understand Client's Requirements. 2- Brainstorm on them. 3- Analyze the dependencies. 4- Discuss requirements with client and give suggestions. 5- Plan 6- Execute Plan and Develop 7- Deliver 8- Updates if required It would be my pleasure to provide you further insights on my technical and personal abilities and show you the projects that i have worked on. Thank you for considering me for this position and hoping to hear from you soon. Regards, Farhan Jamil

$30 USD în 1 zi

0,0

(0 recenzii)

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 în 1 zi