Charles

Certainly is, but its hidden a bit. The name of the Tag is held in the TERM tables. The join from Survey is via Survey_Tag and Concept.

SELECT Survey.Item_Name, Term.Item_Name
FROM SURVEY INNER JOIN Survey_Tag ON SURVEY.SURVEY_KEY = Survey_Tag.Survey_Key
INNER JOIN Concept ON Survey_Tag.Concept_Key = Concept.Concept_Key
INNER JOIN Term ON Concept.Term_Key = Term.Term_Key

To return all Surveys even if they do not have a tag.

SELECT Survey.Item_Name,Term.Item_Name
FROM SURVEY RIGHT JOIN Survey_Tag ON SURVEY.SURVEY_KEY = Survey_Tag.Survey_Key
RIGHT JOIN Concept ON Survey_Tag.Concept_Key = Concept.Concept_Key
RIGHT JOIN Term ON Concept.Term_Key = Term.Term_Key

Mike