tblInsHours = person_id c(11) ihours n(3) tblNonHours = person_id c(11) nhours n(3)I want to combine these two tables and end up with
tblTotalHours = person_id c(11) ihours n(3) nhours n(3)I want a full outer join on the tables. So, that if a person_id appears on one table, but not the other, it is still included in the sum of the two tables. I don't think I can use UNION, because the structure of the tables are different, and I want to keep the two kinds of hours separate.