i'm trying to get query the relationship between topics and their assignments, but sf doesn't seem to be recognising the relationship between the two.

topics have a many to many relationship with feeditems, through a link table object, topicassignment.

on workbench, it clearly shows a parent:child (one to many) relationship from topics to topic assignments via the topicid key; AND a similar relationship from feeditems to topicassignments, though the entryid key.

however, i don't seem to be able to get any of these relationships (the many to many relationship of topics to feeditems, or the implied one to many relationships of topic to assignment and feeditem to assignment)

the following queries:

• SELECT id, name, (SELECT id FROM TopicAssignments) FROM topic
• SELECT id, (SELECT id FROM TopicAssignments) FROM feeditem
• SELECT id, name, (SELECT id FROM entries) FROM topic
• SELECT id, name, (SELECT id FROM feeditems) FROM topic
• SELECT id, name, entry.id FROM topicassignment
• SELECT id, name, topic.id FROM topicassignment

all result in "Didn't understand relationship"

any help would be greatly appreciated.