Re: Weird Filzlaus

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 - 09:55:08 CDT