i have 2 table, one table called
info
with column
id | name | sick_leave | vacation_leave
example: 1 robert cruz 24 24
seconde table
filed
with column
id | name1(related to info table column name) | filed_sickleave
example1: 1 1 1
my question is: how can i minus the filed_sickleave from filed table to sick_leave info table
the result is 23 on my sick_leave info table after adding 1 to to filed table filed_sickleave