Say I have a table with the following values
John Smith, Edward Jones, 4
John Deer, Jane Deer, 2
Edward Jones, John Smith, 4
I would like to have a query that recognizes the first and third entries as similar, selecting only the first and second values and leaving the third out. I can easily do this when the values are in the same order, but I'm having trouble coming up with something that can discern similarity when the values are in arbitrary order like this. Any ideas?
Aucun commentaire:
Enregistrer un commentaire