SQL Query on Value in Table Multiselect Field

Hi everyone. I am trying to write a query that selects records from a doctype based on a given value selected inside a table multi-select field in the same document.

I’m having a terrible time figuring out how to write this query. Can anyone provide assistance?


use same as child table.
it works for me