si_carter_987654321 wrote: > I have two almost identical sets of records, what would be the most efficient > way of detecting records that are different in the table based on a single > column?
If you only want to view the difference, I recommend using FBCopy with XH option. It creates a nice HTML table showing both old and new values. Otherwise, do the inner join on key columns and use IS DISTINCT FROM on all non-key columns. HTH -- Milan Babuskov ================================== The easiest way to import XML, CSV and textual files into Firebird: http://www.guacosoft.com/xmlwizard ==================================