Try out query with UNION also
select A,B,C from
(select A,B,C from X
UNION
select A,B,C from Y)
group by A,B,C
having count(*)>1
From: Gian Karlo C
To: mysql@lists.mysql.com
Sent: Sunday, 2 October 2011 12:49 PM
Subject: Join 2 tables and compare t
Hi All,
I decided to join and write to the list hoping someone could help and shed a
light on me.
Here's the scenario.
I have a database running in mysql 5.x in Centos 5. The database has 2
tables that is almost identical with some additional fields.
Table 1
Name, IPAddress, Description, Issue,
