Hi Neil -
Something like this ought to work, joining on the ID column to find matches
between tables, then finding the enabled fields which are not equal.
SELECT a.fieldID, a.enabled, b.enabled
FROM TableA a, TableB b
WHERE a.fieldID = b.fieldID
AND a.enabled != b.enabled
Dan
On 9/15/06,
This may be the blind leading the one-eyed, but wouldn't
SELECT FieldID FROM TableA, TableB WHERE TableA.FieldID = TableB.FieldID AND
TableA.Enabled != TableB.Enabled;
Work?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: