RE: can this be done with SQL - a record is one file or the other

I suppose, in the not too distant future, you could run:

select
case when hdvoucher is null then advoucher else hdvoucher
end as voucher,
case when hdvendor is null then advendor else hdvendor end
as vendor,
case when hdinvoice is null then adinvoice else hdinvoice end
as invoice,
case when hdpostingdate is null then adpostingdate else
hdpostingdate end as postingdate
from qtemp.apohd full outer join qtemp.aphhd
on hdvoucher=advoucher and (
hdvoucher=1235 or advoucher=1235)

Rob Berendt