i have two tables each with the following fields:
NumberOfAbsences; LastName; MiddleName;FirstName; Studentid; YearNo.
I want to combine them, adding the NumberOfAbsences fields to each other.
part of the problem is that not every student is in both tables. so studentid 1 might have 3 absences in the first table but isn't listed at all in the second. in the combined table he should be listed with 3 absences.