Date: 09/07/07 (MySQL Communtiy)    Keywords: no keywords

Several large tables linked by a common ID contain duplicate rows (across all tables).

Is there a way to identify these rows with a SELECT query?

[B]t1[/B]
id val
1 3.4
2 4.4
3 4.4

[B]t2[/B]
id val
1 1.1
2 10.3
3 10.3

SELECT t1.id FROM t1 LEFT JOIN t2 ON t1.id=t2.id WHERE (???)

Source: http://community.livejournal.com/mysql/118315.html