G
Guest
I have a table that has a text field that contains a list of names separated
by commas.
Table 1
Cause Effect ID
Primary Tag Name
Associated Tags (this is a comma separated list)
Table 2
Tag Name
Tag Description
Other Tag information...
I want to create a query that will list all the records for a specific Cause
Effect ID and the details of all the tags in the Associated Tags field
This looked quite simple to me. I thought I could join the two tables where
[Tag Name] IN([Associated Tags]). I have not been able to get this to work.
I have tried adding quotes around each tag name in the Associated Tags comma
separated list but this didn't work either. What am I doing wrong?
by commas.
Table 1
Cause Effect ID
Primary Tag Name
Associated Tags (this is a comma separated list)
Table 2
Tag Name
Tag Description
Other Tag information...
I want to create a query that will list all the records for a specific Cause
Effect ID and the details of all the tags in the Associated Tags field
This looked quite simple to me. I thought I could join the two tables where
[Tag Name] IN([Associated Tags]). I have not been able to get this to work.
I have tried adding quotes around each tag name in the Associated Tags comma
separated list but this didn't work either. What am I doing wrong?