I have a mysql Database that has 2 tables:
Table1 - Batch:
Table2 - jobs
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 Passed
=2 0 Failed
1 1 Failed
0 1 Passed
0 2 Failed
Can anyone please help me?
I have begain learn SQL last week and this seems to be complex ...