>>>> 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

Hi Larry,

Glad to be of so much of help. :)