Tag Info

New answers tagged

1

The condition: AND A.name = B.name only allows identical names, while you obviously want to match names with the same soundex value. So make that: AND soundex(A.name) = soundex(B.name) If gid is the primary key, you can also simplify to: GROUP BY a.gid, b.gid However, since there obviously is no aggregation at all, you can simply remove the ...



Top 50 recent answers are included