Need help to Update Database

[ruiascensao]

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

[admin]

Rui,

Its more a SQL question than a nuBuilder one.

you could try http://www.dbforums.com/mysql/

Steven

[ruiascensao]

Thank you for your suggestion.

Best Regards,
Rui

[admin]

.