MySQL Forums
Forum List  »  Newbie

Compare identical tables and return the difference
Posted by: fresh3_16
Date: May 18, 2005 08:36AM

Hello,

I am trying to compare to Idential tables to get the records that are different, is there any query that I can use to accomplish this? Or do I have to parse each table separately.

eg.

Table 1 Table 2
------------ --------------
Name Name
Number Number
Address Address

So the query should only return the name, number and address that are not present in both tables

Thanks in advance

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.