i have 3 tables:
links (id, linkName)
tags (id, tagName)
tagsBridge (tagID, linkID)
i am trying to support showing related tags like in SOF. so if you click on tags "XYZ", right now i am showing all the links with tag "XYZ" but i also want to show the distinct list of all other tags that people have tagged those items that also have tagged" "XYZ"
what is the fastest way to query this