In the "I think I'm brain dead" department, I'm trying to do a full outer join on two tables, with slightly different structures.

I've got two tables:

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.

I've been messing with the FULL OUTER JOIN syntax, but get, among other things, records with a .NULL. in the person_id field...which doesn't make any sense.

Thanks!