SELECT <otherfields>, tnprc.billdate, <morefields>, tnprc.stockdate, ..... FROM a09tnprc tnprc ; ... INTO CURSOR asdfg ... brow norm && all is well till here diff. dates for bill and stock dates SELECT * ; FROM asdfg ; UNION ALL ; SELECT <otherfields>, tstjv.jvdate AS billdate, <morefields>, tstjv.jvdate AS stockdate, ..... FROM a09tstjv tstjv ; ... INTO CURSOR asdfg brow norm && when a09tstjv does not return records a09tnprc dates for billdate has become stock datesIn the case where there are no records present for a09tstjv, the records pull for a09tnprc will have the same dates for billdate and stockdate when in actual they are different.