Re: CASE? DECODE?
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Thu, 20 Mar 2008 22:24:49 +0100
Message-ID: <47e2d627$0$14352$e4fe514c@news.xs4all.nl>
> 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!
Date: Thu, 20 Mar 2008 22:24:49 +0100
Message-ID: <47e2d627$0$14352$e4fe514c@news.xs4all.nl>
<mtek_at_mtekusa.com> schreef in bericht
news:f1fc65af-4cde-4856-9fa0-1f401c29a20d_at_s50g2000hsb.googlegroups.com...
> 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!
You could put it in a view.... but I think that's just cosmetic...
Shakespeare Received on Thu Mar 20 2008 - 16:24:49 CDT