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

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

Rowe, Sheri wrote:
> Hi iSeries Guru's,
>
> Can anyone tell me if I can do this with SQL and if so how?
>
> I have a Vendor File APOHD and a Vendor History file APHHD.   A voucher
> will either be in one file or the other, not both, as once a voucher is
> closed it will be in the History file.  Both files contain the same
> information, but have different field names.
>   
SELECT File1Voucher as Voucher, File1Vendor as Vendor, (...)
  FROM File1
UNION
SELECT File2Voucher as Voucher, File2Vendor as Vendor, (...)
  FROM File2

This assumes the fields, although named differently, have the same 
attributes.

Joe