Re: CASE? DECODE?

On Mar 20, 8:36 am, "Shakespeare" <what..._at_xs4all.nl> wrote:
> <m..._at_mtekusa.com> schreef in berichtnews:e14f8636-810f-4d22-ae36-f656f499cb56_at_13g2000hsb.googlegroups.com...
>
> > On Mar 19, 2:12 pm, "Shakespeare" <what..._at_xs4all.nl> wrote:
> >> <m..._at_mtekusa.com> schreef in
> >> berichtnews:439a3392-bd48-4a12-b9cd-134e5612074f_at_m44g2000hsc.googlegroups.com...
>
> zzzzzzzzzzaaaaaaaaaapppppppppppppp
>
> >And your comments about the relationship: We just need to eliminate
> >certain email addresses that meet a different criteria, using
> >different tables......
>
> Ok, then it makes sense to me!
>
> I'm not sure about the with..as but why don't you give it a try?
>
> Shakespeare

Well, I did, and it does not work. But, I thought you may know if I was using the wrong syntax.

At any rate, I'll keep trying to think of more ways to compact the code. Specifically the second part of the query.....

Thanks! Received on Thu Mar 20 2008 - 08:38:53 CDT