>I'm stuck. For the past month I have been trying to compare the contents of two tables within a data base, and identify any records that do not match. Each table (named pam93a & pam93b) contains 39 records, 10 fields long. The records that do not match are to be added to an "output" table. I have checked and double checked my code, but the program still has bugs in it. I purposely inserted, into pam93a, two mistakes, in order to see if the program would pick up on it. Instead of printing the two records that contain the mistakes it printed 1482 records, way more than the 39 in the table! Like I said, I'm stuck! If anyone can help I'd truely appreciate it. The actual code is listed below (It's Short)
Tony
Look in SQl - Select under 'Outer Joins'. Find all the docs you can get on this. It is actually the best & fastest way that I know of.
HTH,
Tom