>>> complete utter solution

>NVL() function should help you. Something like (not tested)

SELECT NVL(ins.person_id, non.person_id) AS person_id, ;
>		INT(NVL(ins.nhours, 0)) AS ihours, ;
>		INT(NVL(non.nhours, 0)) AS nhours ;
>	FROM tblInsHours ins ;
>		FULL OUTER JOIN tblNonHours non ;
>			ON ins.person_id = non.person_id ;
>	INTO CURSOR tblTotalHours		
>

It works it works!

Not only does it solve my problem, but I didn't know you could use the table alias as shown in your example, and I didn't know about the NVL function.

Many Many Thanks, Sergey.

-- L