Thread: CASE? DECODE?
View Single Post

   
  #10 (permalink)  
Old 03-20-2008, 01:46 PM
mtek@mtekusa.com
 
Posts: n/a
Default Re: CASE? DECODE?

On Mar 20, 8:36 am, "Shakespeare" <what...@xs4all.nl> wrote:
> <m...@mtekusa.com> schreef in berichtnews:e14f8636-810f-4d22-ae36-f656f499cb56@13g2000hsb.googlegroups.com...
>
> > On Mar 19, 2:12 pm, "Shakespeare" <what...@xs4all.nl> wrote:
> >> <m...@mtekusa.com> schreef in
> >> berichtnews:439a3392-bd48-4a12-b9cd-134e5612074f@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!
Reply With Quote