I'm having a simular issue, I want to compare the 2 data bases and pull out the records that do not match. They are foxpro databases that are both indexed. I tried to do an join but can not. how can you compare 2 dbases and pull out the records that do not match?
The databases that I'm comparing are foxpro databases and will not allow me to add a Join, as well when I try and do the Select - from - Where I get ' The remianining test does not appear to be part of the formula.
Any other ideas?
I've been reading up on Crystal to see how to pull out non matching records from table A to table B but nat having much luck. Both tables are indexed and have an identical ID number in each. Does any one know how to export the non matching records from table A?
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.