Re: Weird Filzlaus

yes, i guess it is a joke :-)

filzlaus means "pubic louse" :-)
except if you have a medical database, bue then i guess they would have used a medical expression

all entries in your table should be (in any normal case) unequal to 'filzlaus' therefor
it is a dummy anyway

Matthias Gresz wrote:

> In article <25d66e61.0109190612.dedef16_at_posting.google.com>, Roman Morokutti
> says...
>
> Hi Roman,
>
> since it's a matter of contents not syntax, it's up to you to decide wether the
> check against 'FILZLAUS' is necessary or not. Maybe it's just a joke.
>
> Matthias
>
> >
> >Hi,
> >
> >I have a strange problem with a SQL statement. The main aspect is, that I do
> >not understand why there is a check against "Filzlaus" in the statement. Does
> >anyone know how to build the statement, that "Filzlaus" is not needed
> >anymore. Your help would be greatly appreciated. Thanks in advance.
> >
> >Greetings Roman
> >
> >SELECT A.APL,
> > A.APLTXT,
> > A.TERMINAL,
> >
> > B.GRP, B.MODUS,
> >
> > C.ABT,
> >
> > D.BEREICH
> >
> >FROM fact.APL_EBENE0 A,
> > fact.APL_CFG B,
> > fact.APL_GRPCFG C,
> > fact.APL_ABTCFG D
> >
> >WHERE A.APL <> 'FILZLAUS'
> >AND (B.MODUS = 'TEAM')
> >AND (A.APL = B.APL)
> >AND (B.GRP = C.GRP)
> >AND (C.ABT = D.ABT)
> >AND (B.MODUS = C.MODUS)
> >AND (C.MODUS = D.MODUS)
> >
> >UNION SELECT
> > A.APL,
> > A.APLTXT,
> > A.TERMINAL,
> > '',
> > '',
> > '',
> > ''
> >
> >FROM fact.APL_EBENE0 A
> >
> >WHERE A.APL <> 'FILZLAUS'
> >AND NOT EXISTS (SELECT E.GRP FROM APL_CFG E
> > WHERE (E.APL = A.APL)
> > AND E.MODUS = 'TEAM')
> >
> >ORDER BY APL
Received on Wed Sep 19 2001 - 23:54:35 CDT