As Mark pointed out, it's bad design to store a list in a field.
This will work in MS Access (using the sample Northwind database that comes
with it):
SELECT Customers.ContactTitle,Employees.Title
FROM Customers, Employees
WHERE InStr(ContactTitle,Title) > 0;
In this example, ContactTitle would be your list
-David
On Wednesday, June 27, 2001 2:40 PM, David Clay [SMTP:[EMAIL PROTECTED]]
wrote:
> I have more than 1 value in a table field (values=test1,test2)
>
> How can I query those to match one of those values with a value of another
> table?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
