/ FAX: 860.674.8341
-Original Message-
From: Neil Tompkins [mailto:[EMAIL PROTECTED]
Sent: Friday, September 15, 2006 5:04 AM
To: mysql@lists.mysql.com
Subject: Show differences between two tables
Hi
I've two tables
TableA
FieldID
Enabled
TableB
FieldID
Enabled
What query would I ne
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, Neil
Hi
I've two tables
TableA
FieldID
Enabled
TableB
FieldID
Enabled
What query would I need to show what FieldIDs which are the same, but the
enabled field status is different ?Thanks,
Neil
_
Be one of the first to try Windows Live
