G
Guest
Unfortunately, I've encountered a "Memo" field with comma seperated values
that I'm trying to query on and have no idea how to do this. Essentially,
what I need to do is look up my unique ID from one table in the comma
seperated memo field in another table and return the value of another field
in the same table as the comma seperated value.
One table is named: dbo_COMPANY
the field in this table that is unique is: COMPANY
The other table is named: dbo_PREDEF_LIST
the memo field with the comma seperated values containing COMPANY is: LIST
the field value I need to return from this table associated with where
COMPANY is found in the LIST field is: NAME
Can any one help me write this query?
Thank you!
T
that I'm trying to query on and have no idea how to do this. Essentially,
what I need to do is look up my unique ID from one table in the comma
seperated memo field in another table and return the value of another field
in the same table as the comma seperated value.
One table is named: dbo_COMPANY
the field in this table that is unique is: COMPANY
The other table is named: dbo_PREDEF_LIST
the memo field with the comma seperated values containing COMPANY is: LIST
the field value I need to return from this table associated with where
COMPANY is found in the LIST field is: NAME
Can any one help me write this query?
Thank you!
T