One of the tables (T1 in the example)
Has the ID's from T2, inserted with forward slashes 2/1/etc... separating each number.
I did it this way, so I would only have one record in the T2 table for each person's name.
And then each name's ID is referenced from the T1 WID column.
This is what my data looks like
Table = T1
Column = Values (4 record)
WID | 1/2/5 , 2/4, 5/2, 1/4/3
Table = T2
Column = WrID
Values = 1,2,3,4,5
If I give it a query of
Then I only want to get back all records that have the number 4
So, in this case, would be the 1st and 4th record.
With the demo table(s) above.
I need to somehow join WrID and WID.
I looked at Stack Overflow
, and tried the example they had, but was unable to get it to work. Or I might be missing something all together, in making it work in my case.
Any advice on this one would be great.