I have 2 tables supporting a marathon race. Table 1 contains 2 columns. Col 1 is Chip# - a 7 character field Col 2 is a persons Name
Table 2 contains 1 column, chip# When a runner completes the race, the chip# is entered into table 2. I need to compare the 2 tables using table 1 as the master and find out if there are any missing chips.
No 2 chip numbers are the same, and both tables are indexed on Chip#. There could be as many as 35,000 chips involved.
For the life of me, I cant figure out how to do a compare of the two tables using opal Query and come up with missing chips.
Steve I hid the wrong key...Thanks for the assist. I have been away from Paradox for too long! Works like a champ! Now I won't have to go thru thousands of timing chips that the runners wear, comparing them to the original printout Thanks again!
This finds all customers who are not in the Orders table. The inclusion operator (!) after the example _CID tells the QBE engine to find all records even where there is no match; the count = 0 in the Orders CustID field says find only those where the count of CustID in Orders is zero.
Steve Caple Programmer Analyst Prestwood Software http://www.prestwood.com