> 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?
Makes perfect sense, and thanks to Eric too - the only problem is d.id and
m.id are entirely seperate and can't be joined. I see now that I need to
join the tables - what is the thing to do, however, when there aren't any
"joinable" fields?
Thanks for the help,
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
