I need help with how to do this.
I have a table with colums, and one column has system names delimited by a comma.
My challenge is to query each record in this table (the table is very small).
Each record in the table has an ID number, name, and system fields.
The system field can have many entries, delimited by commas.
But I also need to query another table that also has a system field, and I need to match these two table's system fields up and display those records that match, based upon the system field.
Can this be done in one query?
Does this sound like a strange request?
Can someone help with a working example?