Will,
Are you using access? ID is a reserved word, I think. So, number one would
be to change the name of your field in the table. Also, is ID in members the
same as id in fields? If so, you can do something like this:
SELECT m.email, m.id
FROM members m, main_details d
WHERE (d.body LIKE '%m.watch1%'
OR d.body LIKE '%m.watch2%'
OR d.body LIKE '%m.watch3%')
AND d.id = m.id
Make sense?
-d
************************************************************
Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists