Re: comparing one field to another.

2004-01-28 Thread Brandon_Newport
I discovered one more thing about this whole thing that does not make any sense to me but I have been told I have to take into account. Here is what I have Email Table emailAddr (field) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [E

Re: comparing one field to another.

2004-01-28 Thread Brandon_Newport
That works great! My head can take a rest now and the bruises hopefully will heal. Thanks, -brandon David Griffiths <[EMAIL PROTECTED]> 01/28/2004 12:05 PM To [EMAIL PROTECTED], [EMAIL PROTECTED] cc Subject Re: comparing one field to another. I'm not sure you can do that in a singl

comparing one field to another.

2004-01-28 Thread Brandon_Newport
I have been beating my head against the wall for a couple of days now and cannot figure this out. I am hoping that it can be done. I have two tables each with only one field. Table 1 - emailAddress (this contains things like [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTEC