Dataview table list all notes tagged "symptom" and notes that contain those links

[cedardoc]

What I’m trying to do

Lets say I have 3 notes that contain the tag “symptom”: [[headache]], [[neck pain]], and [[shoulder pain]]

I also have the note [[note 1]] that contains the link [[headache]]
I have the note [[note 2]] that contains the link [[neck pain]]
I have the note [[note 3]] that contains the links [[neck pain]] and [[shoulder pain]]

How do I get a table that lists something like this:
headache | [[note 1]]
neck pain | [[note 2]] [[note 3]]
shoulder pain | [[note 3]]

the closest I have found is something like

TABLE join(that.file.link, ", ")  <-- not actually functional
From #symptom
SORT file.name ASC

I did get one that would show backlinks, but that only referenced links going out from the [[headache]] note for example, but I need all the other files that reference to “[[headache]]” from within them.

Things I have tried

lots of google searching and failing various solutions, and ChatGPT very confidently gives me crappy solutions, ha ha

[alltagsverstand]

Is this what you want?

TABLE WITHOUT ID link(file.link,title) AS Note, file.inlinks
FROM #symptom

In case you are using metadata with title attributes - or even simpler if you just want the file name to be displayed:

TABLE file.inlinks
FROM #symptom

[cedardoc]

Yes, that’s it!

Thank you!!