SELECT Table1.Date AS DateA, ABal, Table2.Date AS DateB, BBal ; FROM Table1 ; FULL OUTER JOIN Table2 ON Table1.Date = Table2.Date ; INTO CURSOR (SYS(2015)) lcAlias = ALIAS() SELECT IIF(ISNULL(DateA), DateB, DateA) AS Date, ABal, BBal ; FROM (lcAlias) ; INTO CURSOR c_result USE IN (lcAlias)You could have the option of using IIF(ISNULL()) or NVL() constructs to strip nulls from ABal and BBal in c_result if you couldn't deal with nulls or wanted to see specific values where nulls were found.