|
Trying to identify
Records in file a not in file b
Records in file b not in file a
Records that match key but have any differences
This is what I'm trying
(select * from prodfiles/ufxd where ufact = ufact
except
select * from qtemp/ufxd )
union
(select * from qtemp/ufxd
except
select * from prodfiles/ufxd where ufact = ufact)
If this works as I think, I need to identify whether the results are in file a or file b
Not sure what to do
Thanks
Mike
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.