I figured out how to display a list of duplicate values from an individual database table. However, I haven't yet figured out how to display duplicates in a series of tables.

Examples of the kinds of duplicates I might expect include URL = George_Washington (the name of a U.S. president displayed at MySite/People/George_Washington and a ship @ MySite2/Topics/George_Washington) and URL = Gary_Locke (a person discussed in two articles at MySite/People/Gary_Locke and MySite2/People_Gary_Locke).

In summary, I simply want to display a list of every value in the field URL (which corresponds to the fields Taxon and Name). It would be really cool if I could display a list of URL's with their respective sites and sections, like this:

P.S. Is CREATE VIEW something that can only be done in phpMyAdmin > SQL, or can it be used to replace a more traditional query on a web page? It looks like an SQL thing to me, but some of the tutorials I've checked out make it sound like people actually use it on their web pages.