Hi,
I have 2 tables:
Table1 - Batch:
batch_id
batch_code
batch_min
batch_max
batch_status
Table2 - jobs (subform)
jobs_id
jobs_batch_id
jobs_code
jobs_min
jobs_max
I need to write a sql statemente to update the database:
batch_max=SUM(jobs_min) and Batch_min=sum(jobs_max) where batch_id =jobs_batch_id.
Then I need to change de batch status:
batch_max | batch_min | batch_status
>= 1 | 0 | Failed
1 | 1 | Failed
0 | 1 | Passed
0 | 2 | Failed
Can anyone please help me?
This seems to be complex ...
Thank You!
Rui
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
Need help to Update Database
-
- Site Admin
- Posts: 2781
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 1 time
Re: Need help to Update Database
Rui,
Its more a SQL question than a nuBuilder one.
you could try http://www.dbforums.com/mysql/
Steven
Its more a SQL question than a nuBuilder one.
you could try http://www.dbforums.com/mysql/
Steven
-
- Posts: 177
- Joined: Tue Nov 15, 2011 2:24 pm